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.)
Parameter | Description |
---|---|
date | Required. Any valid date expression (like Date() or Now()) |
How to use CDate to convert a string to a time object: