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
 
Back
Top