Criteria

  • Thread starter Thread starter jwebb
  • Start date Start date
J

jwebb

I am looking for a query to only pull in records with a
date of from today (now) - 90 days. What would I put into
the criteria section of the query?

TFTH,
Jay
 
jwebb said:
I am looking for a query to only pull in records with a
date of from today (now) - 90 days. What would I put into
the criteria section of the query?

TFTH,
Jay
Click to expand...

Assuming all dates have a time of midnight...

BETWEEN Date()-90 AND Date()

If they do contain times other than midnight then...

BETWEEN Date()-90 AND Date()+1
 
You must log in or register to reply here.

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 search query 0
Access Dcount (multiple criteria) 3
date range in a query 2
Between Date and Time Query 8
Filtering in a Query 5
Criteria for age calculation 5
Using the "Forms Object" on more than field in a query table 2
Pulling out right ID number 5

Back
Top