MS Access DateValue() Function

Return a date based on the given string:

SELECT DateValue("May 17, 2017");

Definition and Usage

The DateValue() function returns a date based on a string.

Note: If the given string does not include a year component, this function will use the current year.

DateValue(string_date)

Parameter	Description
string_date	Required. A string that represents a date (from January 1, 100 to December 31, 9999)

Works in:	From Access 2000

Return a date based on the given string (without year component):

SELECT DateValue("May 17");