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.