WinSQL » Knowledge base

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


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 Chris on 2/26/19 7:22 PM

If you get an error in the GUI about not being able to rename the 'synaman.pfx' file during this process, go to synaman\htdocs\sslCert and rename the synaman.pfx file manually then go through the process again.

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?

Important: This area is reserved for useful tips. Therefore, do not post any questions here. Instead, use our public forums to post questions.


Social Media

Powered by