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?