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!
Office Suites
- Datevalue@gmail com
- Datingvalue@gmail.com
- Access datevalue
- Accessing and downloading > Forum - Facebook
- Can't access facebook website [solved] > Forum - Internet/Social Networks
- How to access locked facebook account > Guide
- How to download Facebook data: on mobile and on desktop > Guide
- Access denied unable to connect printer [solved] > Forum - Windows
- Adobe Acrobat Reader change language: to English, settings
- How to disable spell checking LibreOffice
- Change background on Teams: before or during meeting
- How to reset LibreOffice: to default settings
- Change WordPad's default font
- Open a .PS file: online, in Windows
- Pro11.msi download: for office 2003, installation package
- Microsoft Office: free download, 2021
- Office 2013 system requirements
- How to hide grid lines in LibreOffice
- How to change Scribus theme
- Recover deleted PST file: Outlook, from hard drive, free
- How to open Outlook email in browser
- Automatically save screenshots: to OneDrive
- How to change the text capitalization: Word,Excel,OpenOffice
- Open Office Writer background image
- Create a team and channels in Microsoft Teams