Data Studio is now Looker Studio. Looker Studio is still free, with the same features you already know. Looker Studio Pro offers improved asset management for enterprises, new team collaboration capabilities, and access to technical support. Learn more.

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?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
true
true
true
102097
false
false