Smartstaff
56
edits
Changes
no edit summary
== Adding business days within report builder==
To add business days to a date field within the [[report builder]], you will need to use the built-in SS_FUNC.addbusdays functionwithin the [[Calculated Field]] line.
SS_FUNC.addbusdays(xxxxxx,[y],z)
where x = Root company ID, y = Date column in report builder, z = number of business days
Example:
If my [[Determining the root companyid|Root Company ID]] is 12345,
To add 5 business days to a date located on column 2 you will enter the following:
SS_FUNC.addbusdays(12345,[2],5)
For a workflow calculation to add three business days to a submitted date on a level 1, see the below example:
Update to custom field value using field referenced below:
<pre style="white-space: pre-wrap;
white-space: -moz-pre-wrap;
white-space: -pre-wrap;
white-space: -o-pre-wrap;
word-wrap: break-word;">
< !--@sscalculation(SS_FUNC.addbusdays("@Date_Submitted@",3))-->
</pre>
==See Also==
* [[Holiday Calendar]]
* [[Template_/_Type_Formula#Counting_and_Adding_Business_Days|Using Template Formulas to Count and Add Business Days]]
* [[Counting Business Days between Two Dates]]
[[Category:Reports]]
