Date range in a query



I am working on a query that I need to return a certain range of dates in a
date field. I would all records that contain a date that is at least 60 days
from today's date (in the past) but must be 12/28/07 or greater.

What can I use in a query that will return only the records in that range?



John Spencer

I would try

Field: DateField
Criteria: Between #12/28/07# and DateAdd("d",-60,Date())

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question