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.