Date Query

[David A. Hersher]

I have a query that I want to return records between two dates. It looks
something like this:
.....where tap_dt between #4/1/03# and #3/31/04#
What it returns is records for april/03 and 3/04 but no records in between.
Any idea what I am doing wrong? The field tap_dt is a date/time type. This
is Access 97 should that matter.

 

[Allen Browne]

Could there be a problem with the data stored in the table, e.g. it is 1903,
or there is some confusion about which part of the date is the year? In the
Windows Control Panel | Regional Settings | Date, change Short Date to:
mm/dd/yyyy
so you can see a 4-digit year.