Data Type: String expression
Any of the date formats recognized by IsDate.
Variant of type Date.
Returns a Date variant containing the date represented by
DateValue can successfully recognize a
stringexpression in any of the date
formats recognized by IsDate.
DateValue doesn’t return time values in a
date/time string; they are simply dropped. However, if
stringexpression includes a valid date
value but an invalid time value, a runtime error results.
The order of the day, the month, and the year within
stringexpression must be the same as
the sequence defined by the computer’s regional settings.
Only those date separators recognized by IsDate can be used.
If you don’t specify a year in your date expression, DateValue uses the current year from the computer’s system date.
Dim dateExpression dateExpression = #10 March 2003# If IsDate (dateExpression) Then MsgBox DateValue(dateExpression) Else MsgBox "Invalid date" End If
When working with dates, always check that a date is valid using the IsDate function prior to passing it as a function parameter.
time information as well as date information, the time
information is ignored; however, if only time information is
passed to DateValue, an error is