FunctionCopy link to clipboard
workday( starting_date, days, holidays )
Returns the date the given number of workdays before or after the given date.
ParametersCopy link to clipboard
| 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. |
ReturnsCopy link to clipboard
Date
Usage considerationsCopy link to clipboard
An array of holidays may be given by enclosing them in braces, such as {"12/25/2004","12/31/2004"}.
ExamplesCopy link to clipboard
workday(date(2011,12,13),-6) returns 12/5/2011
Feature compatibilityCopy link to clipboard
The table below lists this function's compatibility with various features in Appian.
| 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 | Custom record fields that evaluate in real time must be configured using one or more Custom Field functions. |
| Process Reports | Compatible | |
| Process Events | Compatible |
FeedbackCopy link to clipboard
Was this page helpful?