DAYS function calculates the number of days between two dates.
|end_date||date||Yes||The end of the date range|
|start_date||date||Yes||The start of the date range|
end_date is the same as
start_date, the result will be zero.
end_date is before the
start_date, the result will be negative.
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: