Changes

Jump to: navigation, search

Adding Business Days

191 bytes added, 19:14, 8 November 2012
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 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)
[[Category:Reports]]
0
edits

Navigation menu