Finding Dates in future

D

Dgwood90

I am trying to find experation dates of products in a 90 day window. ie, if
product expires 06/30/06 it will show, if product expires 10/30/06, it will
not show. I have tries the following with no luck, they both show all dates.
 
J

John Spencer

Field: YourField
Criteria: Between Date() and DateAdd("d",90,Date())

The above should work.

Criteria: >=Date() And <= DateAdd("d",Date(),90)
Should also work. Your posted criteria used Greater than for the second part
of the criteria.
 
Top