How to get a date value in Access

How to get a date value in Access

In this article, we are going to see an easy way to convert a string representation of a date to a date value.


To get the date value on Access, you can use the simple function called DateValue:

  • DateValue(string_date)

The string_date can be a date ranging from January 1, 100 to December 31, 9999. It can include a time component if desired.


  • For DateValue ("June 30, 2004") the result is 6/30/2004.
  • For DateValue ("6/30/2004") the result is 6/30/2004.
  • For DateValue ("June 30") the result is 6/30/2004.
any more questions about access? check out our forum!