Date Function


date (expression)


The date function returns expression converted to a date. This is useful for converting strings containing dates into a date value.

If the data type of expression is string or character, it is converted to a date using the default formatting set. If expression is one of the numeric data types real, integer, or long, it is taken as the number of days since January 1, 1800 plus 1. All other data types return an undefined result.


duedate - date ("1/3/89")