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.