Date question

  • Thread starter Thread starter Amin
  • Start date Start date
A

Amin

How do I query for all dates after a certain date?

e.g.
WHERE DateField > 11/01/2008

This is data mismatch obviously. How should I be writing this?

Thanks,
Amin
 
Well, you do need the # character to delimit literal dates.

WHERE [DateField] > #11/1/2008#

That assumes that 11/1/2008 means November 1 2008 and not January 11, 2008.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top