FunctionCopy link to clipboard
networkdays( starting_date, ending_date, holidays )
Returns the number of working days between two specified dates.
ParametersCopy link to clipboard
| Keyword | Type | Description |
|---|---|---|
|
|
Date |
The starting date. |
|
|
Date |
The ending date. |
|
|
Date |
A list of holidays not counted as workdays. |
ReturnsCopy link to clipboard
Integer
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
networkdays(date(2011,12,13),date(2011,12,20)) returns 6
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?