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.
Syntax
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.
Examples
- 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!