Selecting Records in a Quert by Date

  • Thread starter Thread starter Chuck Moore
  • Start date Start date
C

Chuck Moore

I have built a query including a date field. My records
go back for several months. I only want to include the
records for the last 90 days. My date field is
mm/dd/yyyy. I have tried to work with <Now but can't weem
to add a number of days qualifier. Any suggestions?
 
I have built a query including a date field. My records
go back for several months. I only want to include the
records for the last 90 days. My date field is
mm/dd/yyyy. I have tried to work with <Now but can't weem
to add a number of days qualifier. Any suggestions?
Click to expand...

Use a criterion of
DateAdd("d", -90, Date()) AND <= Date()
Click to expand...

Leave off the AND <= Date() if there will never be future records (or
if you want to see them).

Note that Now() is NOT today's date; it's the current date and time
accurate to microseconds.
 
Back
Top