DATE_DIFF

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

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?

Need more help?

Sign in for additional support options to quickly solve your issue