DateValue

Returns the date represented by the date of a String argument.

Arguments

DateValue( stringexpression )

Notes

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.