Returns the date represented by the date of a String argument.
DateValue( stringexpression )
The argument stringexpression is a String representing a date from January 1, 100 through December 31,
9999. If stringexpression includes only numbers, DateValue recognizes the order for month, day, and year according to the Date Format
setting in the International section of the Microsoft Windows Control Panel.
DateValue also recognizes unambiguous dates that contain month names, either long or
abbreviated form. For example, in addition to recognizing 12/30/1994 and
12/30/94, DateValue recognizes December 30, 1994; Dec 30, 1994; 30-Dec-1994; and 30
December 94. If the year part of stringexpression is omitted, DateValue uses the current year from your computer’s system date. If stringexpression includes time information, DateValue does not return it. However, if stringexpression includes invalid time information, an error occurs.
The DateValue function returns a Variant of VarType 7 (Date) containing a date that is
stored internally as a double-precision number. This number represents a date from
January 1, 100 through December 31, 9999, where January 1, 1900 is 2. Negative
numbers represent dates prior to December 30, 1899.