How do I search for a specific date?

  • Thread starter Thread starter How do I search for specific date?
  • Start date Start date
H

How do I search for specific date?

In Design View for query how do I put in that I am
looking for all records from a field with the date
showing up in this format:

mo/da/year

Thanks for any help.
 
SIMPLE.

Today;s date is

3/26/2004.


Access wants to see it as

#3/26/2004# so it knows not to treat the slashes as division
operators. Works with between as well, so you can say "between
#3/1/2004# and #3/30/2004#
 
Back
Top