Syntax |
CDate
(expression)
CVDate
(expression) |
Description |
Converts expression to a date, returning a
Date
value. |
Comments |
The expression parameter is any expression that can be converted to a
Date
. A runtime error is generated if expression is
Null
. If expression is a
String
, an attempt is made to convert it to a
Date
using the current country settings. If expression does not represent a valid date, then an attempt is made to convert expression to a number. A runtime error is generated if expression cannot be represented as a date. These functions are sensitive to the date and time formats of your computer. The
CDate
and
CVDate
functions are identical. |
Example |
This example takes two dates and computes the difference between them. Sub Main()
Dim date1 As Date
Dim date2 As Date
Dim diff As Date
date1 = CDate(#1/1/1994#)
date2 = CDate("February 1, 1994")
diff = DateDiff("d",date1,date2)
MsgBox "The date difference is " & CInt(diff) & " days."
End Sub
|
See Also |
CCur (function); CBool (function); CDbl (function); CInt (function); CLng (function); CSng (function); CStr (function); CVar (function); CVErr (function); Date (data type). |