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())
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

>=[BeginDate] And <=[End Date] 1
Multiple word search Parameter Query 4
Multiple "Not Like" not working 5
I need help on a query. 6
The not "Max" records 1
All records within the last 30 days 2
Need help sorting a query 2
Update Query 10

Back
Top