Description
The CDate() function converts a valid date and time expression to type Date, and returns the result.
Tip: Use the IsDate function to determine if date can be converted to a date or time.
Note: The IsDate function uses local setting to determine if a string can be converted to a date ("January" is not a month in all languages.)
This function has the form:
CDate(date)
Parameter | Description |
---|---|
date | (required) Any valid date expression (like Date() or Now()) |
Examples
The following examples show the basic use of this function:
Example 1
How to convert a string to a date:
d = CDate("April 22, 2010")
Example 2
How to convert numbers with separators to a date:
d = CDate(#4/22/10#)
Example 3
How to use CDate to convert a string to a time object:
d = CDate("3:18:40 AM")
Miscellaneous Information
Supported in Version: | 1.0 |
---|