DAYS

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)
Next item
COUNTDISTINCT