date queries

  • Thread starter Thread starter Brett
  • Start date Start date
B

Brett

I'm trying to limit a query based on a date range such as
4/1/2004. I've tried >= but it seems to only pick up the
first number and disregard the year. I keep getting dates
from other years with months in the late April to December
area. Can you set wildcard dates such as <>%/%/2003. That
didn't work ofcourse...
 
In Access, the asterisk(*) is the wildcard operator. e.g. 12/*/2004.
SQL Server Uses the percent(%).

Using the Between...And construct will help find a range.

WHERE SomeDate Between #1/1/2004# And #1/31/2004#
 
Back
Top