Generate a date based on the provided string representation.
|
SELECT DateValue(“May 17, 2017”); |
The DateValue() function converts a string into a date value.
Note: If the string lacks a year component, the function defaults to the current year.
|
DateValue(string_date) |
|
Parameter |
Description |
|
string_date |
Mandatory. A string that denotes a date, valid within the range from January 1, 100 to December 31, 9999. |
|
WORKS IN |
From Access 2000 |
Generate a date based on the provided string, assuming it does not include a year component.
|
SELECT DateValue(“May 17”); |