0
edits
Changes
no edit summary
'''IMPORTANT''': ''Template formulas will only work if the Template standard field is enabled and visible on the page.''
===Counting and Adding Business Days (Feb 2012 Service Pack)===
Aside from using [[Counting Business Days between Two Dates|Javascript]] to count business days, there are 2 SmartSimple functions you can use within the L1, L2, and L3 template formula to count and add business days to any Date field.
'''To count the number of business days between 2 date fields, use the following function:'''
'''SS_FUNC.businessdays('Date1','Date2')'''
This example below calculates the number of business days between the Start Date and End Date.
'''@level1.DateDifference@=SS_FUNC.businessdays('@level1.Startdate@','@level1.Enddate@')'''
'''To increment a date by a number of business days, use the following function:'''
'''SS_FUNC.addbusdays('Date', x ) where x = # of business days'''
This example below adds 5 business days to the startdate.
'''@level1.DateDifference@=SS_FUNC.addbusdays('@level1.Startdate@',5)'''
Note in order to take into considering holidays, you will need to create a holiday [[Entering_a_New_Calendar_Event|Calendar]] and associate this calender as the holiday calendar within [[Global Settings]].
==Examples==
