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

Formula Result
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?