DATEDIFF
Returns the number of units (unit specified in Interval) between the input two dates.
Syntax
DATEDIFF(<date1>, <date2>, <interval>)
| Parameter | Type | Description |
|---|---|---|
| date1 | Date | A date in datetime format that represents the start date. |
| date2 | Date | A date in datetime format that represents the end date. |
| interval | Text | One of: MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, YEAR. |
Return values
Integer