This function converts an expression to a Variant of subtype Date.
CDate(date)
Returns a Date expression.
Use IsDate to determine if date represents a date or time. CDate recognizes date literals and time literals as well as some numbers that fall within the range of acceptable dates. When you convert a number to a date, you convert the whole number portion to a date. Any fractional part of the number converts to a time of day, starting at midnight.
CDate recognizes date formats according to the locale setting of your system. The correct order of day, month, and year may not be determined if it is provided in a format other than one of the recognized date settings. In addition, a long date format is not recognized if it also contains the day-of-the-week string.