networkdays( starting_date, ending_date, holidays )
Returns the number of working days between two specified dates.
Keyword | Type | Description |
---|---|---|
|
Date |
The starting date. |
|
Date |
The ending date. |
|
Date |
A list of holidays not counted as workdays. |
Integer
An array of holidays may be given by enclosing them in braces, such as {"12/25/2004","12/31/2004"}
.
networkdays(date(2011,12,13),date(2011,12,20))
returns 6
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 |
networkdays() Function