workday( starting_date, days, holidays )
Returns the date the given number of workdays before or after the given date.
Keyword | Type | Description |
---|---|---|
|
Date |
The starting date. |
|
Integer |
The number of days to advance into the future (positive numbers) or days to retreat into the past (negative numbers). |
|
Date |
A list of holidays not counted as workdays. |
Date
An array of holidays may be given by enclosing them in braces, such as {"12/25/2004","12/31/2004"}
.
workday(date(2011,12,13),-6)
returns 12/5/2011
Feature | Compatibility | Note |
---|---|---|
Portals | Compatible | |
Offline Mobile | Compatible | |
Sync-Time Custom Record Fields | Compatible | Can be used to create a custom record field that only evaluates at sync time. |
Real-Time Custom Record Fields | Incompatible | |
Process Reports | Compatible | |
Process Events | Compatible |
workday() Function