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?

Need more help?

Sign in for additional support options to quickly solve your issue