DATE(Y, M, D)

 

Description

This function returns the datetime value corresponding to year Y+1900, month M, and date D.  Y must be in the range 0 to 199, representing 1900-2099.

 

The values returned by this function may not be apparently meaningful, but these values are needed as arguments by operations requiring datetime values:

 

DAYS360(DATE(92, 5, 1), DATE(92, 6, 1)) = 30.

 

Parameters

 

Y

Year.

 

M

Month.

 

D

Day.

 

Examples

 

DATE(66, 4, 6) = 24203

(Corresponding to April 6, 1966.)

 

DATE(366) = #Error

Wrong number or arguments.