THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access DateValue() Function

❮ MS Access Functions

Example

Convert a string to a date:

SELECT DateValue("May 17, 2017");
Try it Yourself »

Definition and Usage

The DateValue() function converts a string to a date.

Note: If the string does not include a year component, the DateValue() function will use the current year.

Syntax

DateValue(string_date)

Parameter Values

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

Technical Details

Works in: Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000

More Examples

Example

Convert a string to a date (without year component):

SELECT DateValue("May 17");
Try it Yourself »

❮ MS Access Functions