CDate Function |
Main Menu |
Syntax
CDate(date)
The date argument is any valid date expression.
Remarks
Use the IsDate function
to determine if date can be converted to a date or time. CDate recognizes date
and time literals as well as some numbers that fall within the range of acceptable
dates. When converting a number to a date, the whole number portion is converted
to a date. Any fractional part of the number is converted 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.
The following example uses the CDate function to convert a string to a date. In general, hard coding dates and times as strings (as shown in this example) is not recommended. Use date and time literals (such as #10/19/1962#, #4:45:23 PM#) instead.
MyDate = "October 19, 1962" ' Define date.
MyShortDate = CDate(MyDate) ' Convert to Date data type.
MyTime = "4:35:47 PM" ' Define time.
MyShortTime = CDate(MyTime) ' Convert to Date data type.
To see example (Click Here)
related to
IsDate
|