DATE_DIFF

Calculates the number of days between two compatibility mode 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

Example 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