Converts text into data accepted by the date data type and functions that require date parameters.
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.
Date
You can experiment with this function in the test box below.
Test Input
date(2009,7,5)
returns 7/5/2009