DateValue Function
Returns a Variant of subtype Date.
DateValue(date)
The date argument is normally a string expression representing
a date from January 1, 100 through December 31, 9999. However, date can
also be any expression that can represent a date, a time, or both a date and
time, in that range.
Remarks
If the date argument includes time information, DateValue
doesn't return it. However, if date includes invalid time information
(such as "89:98"), an error occurs.
If date is a string that includes only numbers separated by valid date separators, DateValue
recognizes the order for month, day, and year according to the short date format
you specified for your system. DateValue also recognizes unambiguous
dates that contain month names, either in long or abbreviated form. For example,
in addition to recognizing 12/30/1991 and 12/30/91, DateValue also
recognizes December 30, 1991 and Dec 30, 1991.
If the year part of date is omitted, DateValue uses the current
year from your computer's system date.
The following example uses the DateValue function to convert a string
to a date. You can also use date literals to directly assign a date to a
Variant variable, for example, MyDate = #9/11/63#. Dim MyDate
MyDate = DateValue("September 11, 1963") ' Return a date.
|