Difference between revisions of "Calculated Value - busdateadd Function"
From SmartWiki
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | {{JavaScript Syntax}} | ||
The JavaScript "busdateadd" function adds a specific number of '''business days''' to a given date. | The JavaScript "busdateadd" function adds a specific number of '''business days''' to a given date. | ||
*Syntax: ''busdateadd(datefield,business days to be added)'' | *Syntax: ''busdateadd(datefield,business days to be added)'' | ||
| Line 4: | Line 5: | ||
It skips Saturday and Sunday and Canadian public holidays (not banking holidays). | It skips Saturday and Sunday and Canadian public holidays (not banking holidays). | ||
| − | |||
| − | |||
This is not related to any [[SmartSimple]] calendar. | This is not related to any [[SmartSimple]] calendar. | ||
| Line 20: | Line 19: | ||
==See Also== | ==See Also== | ||
| + | * [[Manipulating Dates]] | ||
* [[isHoliday]] | * [[isHoliday]] | ||
* [[Custom Defined Holidays]] | * [[Custom Defined Holidays]] | ||
| + | * [[Adding a given number of days to a date based on the value of a dropdown]] | ||
| − | [[Category:JavaScript]] | + | [[Category:JavaScript]][[Category:Date Formats]] |
Latest revision as of 14:48, 13 May 2014
| This feature uses JavaScript syntax |  |
The JavaScript "busdateadd" function adds a specific number of business days to a given date.
- Syntax: busdateadd(datefield,business days to be added)
datefield could be a Standard Field or a Custom Field
It skips Saturday and Sunday and Canadian public holidays (not banking holidays).
This is not related to any SmartSimple calendar.
Impact: This allows 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
frm.startdate is a standard field. To calculate using Custom Field use frm.cf_fieldid.value.
