. Quick Links

Document information

Document ID:	753
Subject:	Writing queries including dates in MS Access
Creation date:	7/29/09 11:37 AM
Last modified on:	7/29/09 11:37 AM

Details

Microsoft Access uses a # sign to enclose date fields. Here is an example

select *
from cars
where manufactureDate >= #7/2/2005#

Another method of using date is MS Access is using the following syntax.

select *
from cars
where manufactureDate >= {d '2005-02-20'}

This syntax works with any database.

User comments

Posted by Anonymous on 7/29/09 11:52 AM

In Access 2003 you can set ANSI92 for a particular database by clicking on Tools > Tables/Queries > check box in lower right corder for ANSI92. Note the warning message that come up and the associated help page ("About ANSI SQL query mode (MDB)") are indeed helpful and important.

Add a comment to this document

Do you have a helpful tip related to this document that you'd like to share with other users? Please add it below. Your name and tip will appear at the end of the document text.

Your name:
Your email:	Hide my email address
Verification code:	Enter the verification code you see above more submitting your tip
Tip:	Please limit tips to 1000 characters

Site map | Contact | Products | Support