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