DATE(Year, Month, Day) DATE(Year; Month; Day)

Year

Number Number

The year, which is taken literally.

Month

Number Number

The month (1 through 12).

Day

Number Number

The day (1 through 31).

Returns

Temporal Temporal

A date representing the given year, month and day.

Returns a date representing the given year, month and day. A month or day outside its natural range carries over into the neighboring components.

Examples

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

Returns a date representing January 1, 2013.

DATE(2024, 13, 1)
DATE(2024; 13; 1)

Returns a date representing January 1, 2025, as the 13th month of 2024 is the first month of 2025.

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

Returns an array of dates representing May 1, 1981 and May 1, 2021.

FORMAT.DATE(DATE(1981, 11, 14))
FORMAT.DATE(DATE(1981; 11; 14))

Returns "11/14/1981" if the configured locale is US English.

fxEngine Shell Want this in your own terminal? A standalone version is coming.
Loading fxEngine Shell

fxEngine Shell for your terminal

A version you install on your own computer is coming. Subscribe to the newsletter to hear when it's ready.