DATE
The DATE function takes Numbers describing a year, month, and day; it uses these to create a DATE, which it returns.
This function requires three Numbers as input. It outputs a Date with the given numbers used as the year, month, and day values.
Declaration
Parameters
year (required, type: Number)
A 4-digit integer; this represents a 4-digit year.
month (required, type: Number)
An integer between 1 and 12; this represents the month of a 12-month year.
day (required, type: Number)
An integer between 1 and 31, representing the day of 31- (or 30-, or 29- or 28-) day year.
Return Values
date (type: Date)
A Date with the year, month, and day values specified by the given Numbers.
Examples
The following example returns a Date indicating February first, 2000:
Last updated