d = DateValue(date)
|date||(Date) Date from 1.1.100 to 31.12.9999|
If the date argument includes time information, then function doesn't return it. However, if date includes invalid time information (e.g. "89:98"), then an error occurs.
If date is a string that includes only numbers separated by valid date separators, then function recognizes the order for year, month and day according to the short date format you specified for your system. Function also recognizes unambiguous dates that contain month names, either in long or abbreviated form. For example, in addition to recognizing 12/30/2020 and 12/30/20, function also recognizes December 30, 2020 and Dec 30, 2020.
If the year part of date is omitted, then function uses the current year from your computer's system date.