The DateValue function converts a string to a Date.
Note: If the year part of date is omitted this function will use the current year from the computer's system date.
Note: If the date parameter includes time information it will not be returned. However, if date includes invalid time information, a run-time error will occur.
|date||Required. A date from January 1, 100 through December 31, 9999 or any expression that can represent a date, a time, or both a date and time|
The output of the code above will be: