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.