Calculates the number of days between two dates.
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
| Formula | Input | Output |
DATE_DIFF(End Date, Start Date) |
End Date : Sep 28 2019
Start Date : Sep 10 2019 |
18 |
DATE_DIFF(End Date, Start Date) |
End Date : Sep 9 2019
Start Date : Sep 10 2019 |
-1 |