DateValue returns a date. The required parameter, date, is usually a string, but any expression that can represent a date, a time, or a date and time ranging from January 1, 100 to December 31, 9999, can be used.
If date is a string that consists of numbers separated by date separators, it recognizes the order for month, day, and year according to the Short Date format specified for your system. If the year is left out of date, the current year is used. Unambiguous month names as strings will be recognized in either long or abbreviated form.
Date separators are characters that separate day, month, and year when a date is formatted as a string, they are determined by your system settings.
Rem DateValue Example 'DateValue returns a date Dim IndepDay, Birthday IndepDay = DateValue("July 4, 1776") Birthday = DateValue("Dec 27 1970") Print "Independence Day:", IndepDay Print "My birthday:", Birthday
Independence Day: 7/4/1776 My birthday: 12/27/1970 (''sample date output is machine dependant'')