Description
The DAYS function calculates the number of days between two dates.
Usages
DAYS(end_date, start_date)
| Argument | Type | Required | Description |
|---|---|---|---|
| end_date | date | Yes | The end of the date range |
| start_date | date | Yes | The start of the date range |
Remarks
If the end_date is the same as start_date, the result will be zero.
If end_date is before the start_date, the result will be negative.
Examples
Calculating the number of days between alert and response
In the RRM Template, we have a response form, that references the alert form. Because each response is related to the alert that it prompted it, we can calculate the number of days it took to respond:
DAYS(RESPONSE_DATE, ALERT.ALERT_DATE)