Date Field: > than 4 years

I

Iram

Hello.
I am creating a query to pull up all item purchased 4 years or older.
In the query "data field" how should I write up the criteria?


Thanks.
Iram/mcp
 
O

Ofer

Try using the DateAdd function to retrieve the data

Select * From TableName Where DateFieldName < DateAdd("yyyy",-4,Date())
 
Top