Difference between revisions of "Adding Business Days"
From SmartWiki
| Line 12: | Line 12: | ||
To add 5 business days to a date located on column 2 you will enter the following: | To add 5 business days to a date located on column 2 you will enter the following: | ||
SS_FUNC.addbusdays(12345,[2],5) | 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: | 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: | Update to custom field value using field referenced below: | ||
| − | <!--@sscalculation(SS_FUNC.addbusdays("@Date_Submitted@",3))--> | + | |
| + | <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== | ==See Also== | ||
Latest revision as of 09:00, 6 July 2016
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 function within 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 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:
< !--@sscalculation(SS_FUNC.addbusdays("@Date_Submitted@",3))-->
