...
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | syntax |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:datedif(date1,date2,date_units) |
|---|
|
networkdays(date1,date2,[arraystring_holidayholidays]) |
| Argument | Required? | Data Type | Description |
|---|
| date1 | Y | datetime | Starting date to compare |
| date2 | Y | datetime | Ending date to compare |
| arraystring_holidayholidays | N | array | An array of string values string | A string literal value formatted as an array representing the valid dates of holidays. | Info |
|---|
NOTE: This value must be a literal value. Column references are not supported. |
|
date1, date2
...
| Required? | Data Type | Example Value |
|---|
| Yes | Datetime (Column reference or date output of DATE or TIME function) | LastContactDate |
...
string_
...
holidays
A string, formatted as an array, which contains the list of holidays, which are factored in the calculation of working days.
Values in the array must be in either of the following formats:
| Code Block |
|---|
['2020-12-24','2020-12-25']
['2020/12/24','2020/12/25'] |
| Info |
|---|
NOTE: This value must be a literal value. Column references are not supported. |
| Required? | Data Type | Example Value |
|---|
| Yes |
Array| String | ['2018-12,24','2018-12-25','2018-12-31','2019-01-01'] |
Example - Date diffing functions
...
