Difference between revisions of "Calculated Value - busdateadd Function"

From SmartWiki
Jump to: navigation, search
m
Line 1: Line 1:
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.
+
The JavaScript "busdateadd" function adds a specific number of '''business days''' to a given date.
 +
*Syntax: ''busdateadd(start date,business days to be added)''
  
'''Impact''':  The client can then do a calculation in a [[Custom Fields|custom field]] based on business days instead of real days.
+
 
 +
It skips Saturday and Sunday and Canadian public holidays (not banking holidays).
 +
 
 +
*(A US version will be available at a late date).
 +
 
 +
This is not related to any [[SmartSimple]] calendar.
 +
 
 +
 
 +
'''Impact''':  This allows a calculation in a [[Custom Fields|custom field]] based on business days instead of real days.
  
 
'''Example''',
 
'''Example''',

Revision as of 14:59, 25 February 2009

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

  • Syntax: busdateadd(start date,business days to be added)


It skips Saturday and Sunday and Canadian public holidays (not banking holidays).

  • (A US version will be available at a late date).

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