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 Val, as follows:

The return value is likely to be meaningless.

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

The return value is the date and time resulting from using Val as the internal representation of the date.

Val is returned unchanged.

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.

An error occurs.

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

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

This function is similar to CDate in Visual Basic.