Finding Dates in future

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

Guest

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.
 
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.
 

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

Date Brackets as an IIf statement 3
Excel Formula - Count Dates from another Sheet 8
Search for dates in future 1
Query between dates - help needed 7
Previous Week Ending Date 2
Min/Max Dates and Group By 2
Amazon are rubbish 14
DATES - Grouping sets of sequential dates 3

Back
Top