Difference between revisions of "Calculated Value - busdateadd Function"

Revision as of 14:36, 24 March 2009

The JavaScript "busdateadd" function adds a specific number of business days to a given date.

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

startdate is a standard field. To calculate using custom field use frm.cf_fieldid.value.

@@ Line 1: / Line 1: @@
 The JavaScript "busdateadd" function adds a specific number of '''business days''' to a given date.
-*Syntax: ''busdateadd(start date,business days to be added)''
+*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).
-*(A US version will be available at a late date).
+*(A US version will be available at a later date).
 This is not related to any [[SmartSimple]] calendar.
@@ Line 16: / Line 16: @@
 busdateadd(frm.startdate.value,1) returns 10/11/2008, Monday
+ startdate is a [[standard field]]. To calculate using [[custom field]] use frm.cf_fieldid.value.
 [[Category:System Management]][[Category:Enhancements]][[Category:Custom Fields]]