DATE_DIFF
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 |
Related resources
Was this helpful?
How can we improve it?