Converts text into data accepted by the date data type and functions that require date parameters.

Syntax

date( year, month, day )

year: (Integer) The year of the date you would like to convert into a serial number.

month: (Integer) It month of the date in number format without leading zeros for a month with one digit.

day: (Integer) The day component of the date.

Returns

Date

Examples

date(2009,7,5) returns 7/5/2009