Difference between revisions of "Calculated Value - busdateadd Function"

From SmartWiki
Jump to: navigation, search
Line 4: Line 4:
  
 
It skips Saturday and Sunday and Canadian public holidays (not banking holidays).  
 
It skips Saturday and Sunday and Canadian public holidays (not banking holidays).  
 
*(A US version will be available at a later date).
 
  
 
This is not related to any [[SmartSimple]] calendar.  
 
This is not related to any [[SmartSimple]] calendar.  

Revision as of 11:58, 24 May 2011

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.

See Also