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.
