DAYS
Use the DAYS function to return the number of days between two dates, as a Number.
Use
DAYS( end_date, start_date )
Returns the number of days between two dates.
| Parameter | Required | Description |
|---|---|---|
| end_date | Yes | the start_date and end_date are the two dates between which to return the number of days |
| start_date | Yes | the start_date and end_date are the two dates between which to return the number of days |
| Returns | Number |
Use with literals
DAYS(DATE(2024, 1, 31), DATE(2024, 1, 1))
returns 30
Use with fields
DAYS(@CompleteDetails.out.ReturnDate, @CompleteDetails.out.LeaveDate)
if field @CompleteDetails.out.LeaveDate is 14/06/2024 @CompleteDetails.out.ReturnDate is 21/06/2024, returns 7
ON THIS PAGE