d = DateValue(date)
|date||(Date) Expression representing a date from 1.1.100 through 31.12.9999|
If the date argument includes time information, DateValue doesn't return it. However, if date includes invalid time information (e.g. "89:98"), an error occurs.
If date is a string that includes only numbers separated by valid date separators, DateValue recognizes the order for year, month and day 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/2012 and 12/30/12, DateValue also recognizes December 30, 2012 and Dec 30, 2012.
If the year part of date is omitted, DateValue uses the current year from your computer's system date.