Difference between revisions of "Adding Business Days"
From SmartWiki
(Created page with '== 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. S…') |
|||
Line 1: | Line 1: | ||
== Adding business days within report builder== | == 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. | + | 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) | SS_FUNC.addbusdays(xxxxxx,[y],z) | ||
where x = Root company ID, y = Date column in report builder, z = number of business days | 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]] | [[Category:Reports]] |
Revision as of 15:14, 8 November 2012
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)