Query Date Teaser!

[Marcus20]

Hi i was wondering if any one could offer some advice on a date problem i am having.

I have a field where the date that stock was checked is entered. So eg Marrs Bars stock level was checked on 17-Sep-02. I want a query however to display items that have not been checked within the last 20 days. So if this worked and i run this query Marrs Bars would not show because the stock level was checked on 17-Sep. However if they had been checked on 17-Aug-02 then they would show because this is longer than 20 days.

Is there a simple expression to display this information??

Cheers for any help!

 

[smed]

In the query put the following criteria in the date field column :

>=Date()-20

 

[Marcus20]

Thanks for the reply but this still does'nt work! If i do this it simply shows what stock items have been checked in the last 20 days wheras i want to show stock items that have not been checked. Any other suggestions?

Cheers!

 

[smed]

Sorry I didn't read the Question properly.

If you want to display items who's date checked is more than 20 days from today

use criteria: <=Date()-20

Smed