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!
Around the same subject
- Datevalue access
- Microsoft access free download > Download - Databases
- Access and downloading > Facebook Forum
- Hello, I have a problems on accessing to my Facebook account > Facebook Forum
- Phpmyadmin access denied > Guide
- Attrib access denied [solved] > Hard Drive & SSD Forum