DATE

Composes a date value from individual components.

Syntax:

DATE(year:number, month:number, day:number)

If a day or month section overflows, DATE will correct automatically into the next period.

Example:

DATE(1964, 9, 15)

returns the date value 15.9.1964.