Calculate the number of days between two compatibility mode dates.
This function only supports compatibility mode dates. We recommend upgrading any older date fields in your data sources to the new Date or Date & Time types and using the DATETIME_DIFF function instead. Learn more.
Sample usage
DATE_DIFF(End Date, Start Date)
Syntax
DATE_DIFF(X, Y)
Parameters
X- a date field or date expression.Y- a date field or date expression.
Notes
DATE_DIFF calculates X - Y. If X > Y, the result is positive, otherwise the result is negative.
Examples
| Example formula | Input | Output |
|---|---|---|
DATE_DIFF(End Date, Start Date) |
|
18 |
DATE_DIFF(End Date, Start Date) |
|
-1 |