DATE

Returns a date with the given attributes.

Return Value

Date/Time

Syntax

DATE( year, month, day )

OR

DATE( year, month, day, hour, minute, second, millisecond )

where:

• year is a four-digit integer.
• month is a one-digit or two-digit integer (1 through 12).
• day is a one-digit or two-digit integer (1 through 31).
• hour is a one-digit or two-digit integer (0 through 23).
• minute is a one-digit or two-digit integer (0 through 59).
• second is a one-digit or two-digit integer (0through 59).
• millisecond is a one-digit to three-digit integer (0 through 999).

You must use one of the two syntax models; otherwise, the system returns an error.