Overdue dates 7 days old or older?

  • Thread starter Thread starter Dave B
  • Start date Start date
D

Dave B

Hi,

I am trying to create a query that will allow me to calculate letters that
are 7 days out of date. I have tried several methods such as Date()-7 this
works fine but wont continue to show the date older than 7 days.

Can anybody shed some light on how i should go about it pls?

Thanks in advance,


Dave
 
Dave,

Try the following in the Criteria: row of your query, for the Date Field
that you are testing:

<=DateAdd("d",-7,Date())


hth,
 
Back
Top