 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / May 2006Finding Dates in future
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. >=Date() And >DateAdd("d",Date(),90) and >= DateAdd("d,90,Date()) 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. > 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. > >=Date() And >DateAdd("d",Date(),90) and >= DateAdd("d,90,Date()) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.