CDate

The CDate function converts a valid date and time expression to type Date, and returns the result.

Syntax :

CDate(date)

Parameter	Description
date	Required. Any valid date expression (like Date() or Now()).

Examples :

Example 1

To convert a string to a date :

d=CDate("June 13, 2010")

Result :

6/13/2010

Example 2

To convert numbers with separators to a date :

dCDate = CDate(#6/13/10#)
DEBUG(dCDate)

Result :

dCDate
= 6/13/2010

Example 3

To use CDate to convert a string to a time project :

dCDate = CDate("3:18:40 AM")
DEBUG(dCDate)

Result :

dCDate
= 3:18:40 AM