DATE function

DATE(year, month, day) DATE(year; month; day)

year — Number or { Number }

The year.

month — Number or { Number }

The month (1 through 12).

day — Number or { Number }

The day (1 through 31).

Returns — Number or { Number }

A sequential serial number representing the given year, month and day.

Returns a sequential serial number representing the given year, month and day.

The value returned from this function can be set as the initial value displayed by a date and time field.

Examples

DATE(2013, 1, 1)DATE(2013; 1; 1)

Returns a sequential serial number representing January 1, 2013.

DATE({ 1981, 2021 }, 5, 1)DATE({ 1981; 2021 }; 5; 1)

Returns an array of sequential serial numbers representing May 1, 1981 and May 1, 2021.

FORMATDATE(DATE(1981, 11, 14))FORMATDATE(DATE(1981; 11; 14))

Returns "11/14/81" if the language of the app is set to US English.