In a formula-type column, the DAY_OPEN_DELTA() function calculates the difference in business days (excluding weekends) between two date-type columns.
-
Function name:
DAY_OPEN_DELTA()
Syntax
DAY_OPEN_DELTA(date_1, date_2)
Calling function parameters in TimeTonic:
- $field_name = field (link, linked table column, number, selection, formula, text...).
- "free text" = free text to add within quotation marks.
- do not use quotation marks for numbers.
Parameters
| Parameter | Description |
|---|---|
date_1 |
The more recent date (the result corresponds to date_1 minus date_2, in business days). |
date_2 |
The reference date to subtract. |
Example
DAY_OPEN_DELTA($End, $Start)
The column returns the number of business days between the two dates, excluding weekends.
There are 10 business days difference between Monday, April 4, 2022, and Sunday, April 17, 2022.
There are 5 business days difference between Thursday, April 7, 2022, and Sunday, April 10, 2022.
There are 0 business days difference between Saturday, April 9, 2022, and Sunday, April 10, 2022.
Return Type
The function returns a number (the difference expressed in business days).
The output type format of the result can be configured in the output field options of the formula editor. For more details, see Output format options in the Formula Column article.
Business Use Case
DAY_OPEN_DELTA() measures a processing time in working days: SLA compliance, response time excluding weekends, actual duration of a service.
Best Practice
Use DAY_OPEN_DELTA() instead of DAY_DELTA() whenever a duration is expressed in working days, so that weekends are not counted.