Difference between revisions of "Adding Business Days"
From SmartWiki
| (6 intermediate revisions by 2 users not shown) | |||
| 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 within the Calculated Field line. | + | 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) | ||
| Line 9: | Line 9: | ||
Example: | Example: | ||
| − | If my Root Company ID is 12345, | + | If my [[Determining the root companyid|Root Company ID]] is 12345, |
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: | ||
| + | |||
| + | Update to custom field value using field referenced below: | ||
| + | |||
| + | <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== | ||
| − | * [[Template | + | * [[Holiday Calendar]] |
| + | * [[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]] | ||
Latest revision as of 10: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))-->
