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

Use TODAY() function as the criteria in a SUMIF formula 1
Range headings 0
query to show where no data in a stated column 0
How to remove a combination of letters and special characters 2
Query to show items before a nominated Date 1
Mail Merge skipping records/sending one at a time 0
Date Range Query 1
=Date() Problem 2

Top