Looker Studio is now called Data Studio. Learn more about this change.

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.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2026年08月26日 UTC.