Date Field: > than 4 years

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try using the DateAdd function to retrieve the data

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