Home  |  About  |   Search   

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

RunCommand Constants

Terms of Use


 

Queries: Solving problems with Dates in SQL

Author(s)
Dev Ashish

(Q)     I am working with generating queries directly from SQL, but I am having some problems (incorrect syntax) with the date section of my SQL.

(A)     It's important to remember that regardless of where you are using Access, if doing SQL from code you need your dates to be in US format dates eg:

" WHERE DateField >= #" & Format$(startDate, "mm/dd/yyyy") & "#"

1998-2009, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer