Date range in a query

C

CMcGrann

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?
 
J

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

Similar Threads

=Date() Problem 2
Date calculation on 2 fields 5
Using Between...And with General Date 2
Returning a dynamic date range 1
query based on date ? 1
Start Date/ End Date query 7
Date not within range query 3
Date Range Query 4

Top