Difference between revisions of "Calculated Value - busdateadd Function"
From SmartWiki
Julia Decker (talk | contribs) |
|||
| Line 2: | Line 2: | ||
'''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, | ||
| + | Lets say field frm.startdate.value = 07/11/2008,Friday | ||
| + | |||
| + | busdateadd(frm.startdate.value,1) returns 10/11/2008, Monday | ||
[[Category:System Management]][[Category:Enhancements]][[Category:Custom Fields]] | [[Category:System Management]][[Category:Enhancements]][[Category:Custom Fields]] | ||
Revision as of 13:35, 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
