Search for experation dates.

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

Guest

I am trying to build a query that will search for dates of safety equipment
that are going to expire. I am wanting a 90 day window. The items are fire
extinguishers and eye wash bottles. I have the tables built with the exp.
date, know I need the query.
 
Try something like

Select * From TableName Where DateFieldName Between Date() And Date() + 90
 

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

Search for dates in future 1
Finding Dates in future 1
Another most-recent date query 0
Excel Formula - Count Dates from another Sheet 8
Date range Query 1
Experation Date 2
Date criteria 12
Query for multiple due dates 8

Back
Top