Microsoft® Visual Basic® Scripting Edition CDate Function | Language Reference Version 1

See Also

##### Description

> Returns an expression that has been converted to a Variant of subtype Date.

##### 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 literals 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

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.