Difference between revisions of "Calculated Value - busdateadd Function"
From SmartWiki
| Line 3: | Line 3: | ||
'''Impact''': The client can then do a calculation in a [[Custom Fields|custom field]] based on business days instead of real days. | '''Impact''': The client can then do a calculation in a [[Custom Fields|custom field]] based on business days instead of real days. | ||
| − | Example, | + | '''Example''', |
Lets say field frm.startdate.value = 07/11/2008,Friday | Lets say field frm.startdate.value = 07/11/2008,Friday | ||
Revision as of 12:36, 10 November 2008
A new javascript function "busdateadd" is available. busdateadd (start date,number of days) It skips Saturday and Sunday and Canadian public holidays (not banking holidays). We will have a US version as well later. This is not related to any SmartSimple calendar.
Impact: The client can then do a calculation in a custom field based on business days instead of real days.
Example, Lets say field frm.startdate.value = 07/11/2008,Friday
busdateadd(frm.startdate.value,1) returns 10/11/2008, Monday
