Overdue dates 7 days old or older?

[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

 

[Cheryl Fischer]

Dave,

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

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


hth,

 

[PC Datasheet]

Dave,

You're so close!

<=Date()-7

That's less-than-or-equal to.