Difference between revisions of "Adding Business Days"
From SmartWiki
| Line 15: | Line 15: | ||
==See Also== | ==See Also== | ||
* [[Holiday Calendar]] | * [[Holiday Calendar]] | ||
| − | * [[Template | + | * * [[Template_/_Type_Formula#Counting_and_Adding_Business_Days|Using Template Formulas to Count and Add Business Days]] |
* [[Counting Business Days between Two Dates]] | * [[Counting Business Days between Two Dates]] | ||
[[Category:Reports]] | [[Category:Reports]] | ||
Revision as of 12:57, 25 September 2013
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)
