Converts a value of any data type to a Date value.

The converted dates are held in Microsoft variant date standard format. Converting other data types to a date is likely to give meaningless results.

The result of the conversion depends on the data type of <value>, as follows:

Boolean: The return value is likely to be meaningless.

Categorical: An error occurs.

Date: <value> is returned unchanged.

Double: The return value is the date and time resulting from using <value> as the internal representation of the date.

Long: The day is <value> days after 30 December 1899 (or before, if <value> is negative) and the time is 00:00:00.

Object: If the object has a default property, the value of that property is converted. Otherwise an error occurs.

Text: The string is parsed according to the locale to extract the value. An error occurs if the string does not contain a properly formatted date.

If <value> is NULL, the return value is 30 December 1899 00:00:00.

This function is similar to CDate in Visual Basic.