Notification

This Help Center is moving to Cloud. Learn more about the migration.

DATE

Creates a date.

Sample usage

DATE(Year, Month, Day)
 
DATE(Order Date and Time)

Syntax

1) Create a Date from Numbers.

DATE(year, month, day)

2) Create a Date from a Date & Time.

DATE(datetime_expression)

Parameters

  • year - a Number field or expression representing the year.
  • month - a Number field or expression representing the month.
  • day - a Number field or expression representing the day.
  • datetime_expression - a Date & Time field or expression.

Return data type

Date

Examples

Example formula Output
DATE(2020, 1, 10) 2020-01-10
DATE(DATETIME "2020-1-10 23:59:59") 2020-01-10

Notes

This function is not available for compatibility mode date types.

Related resources

Was this helpful?

How can we improve it?
true
What's new in Looker Studio?

Learn about new features and recent changes. Looker Studio release notes live on Google Cloud.

Search
Clear search
Close search
Google apps
Main menu
14769070534258664854
true
Search Help Center
true
true
true
true
true
102097
false
false