Adding Business Days

From SmartWiki
Jump to: navigation, search

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.


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))-->

See Also