Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

90 day look ahead

Status
Not open for further replies.
winnieisme

winnieisme

Technical User
Aug 14, 2003
16
0
0
US
I am creating a query where I am using a frequency table. In the criteria part I need it to do a 90 look ahead. How do I do that?
 
Sort by date Sort by votes
90 days from TODAY? 90 calendar days (vs. 90 working days)?

try dateadd() function

<=dateadd("d",90,date())
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

brendoaccess
  • Locked
  • Question
Look up fix
Replies
2
Views
33
dhookom
dhookom
meagain
  • Locked
  • Question
If Conditional Expression based on day of week
Replies
2
Views
70
meagain
meagain
Lhuffst
  • Locked
  • Question
Date code adds a day but why??? 2
Replies
13
Views
71
Lhuffst
Lhuffst
mart10
  • Locked
  • Question
Excel Matrix lookup intersection
Replies
3
Views
21
dhookom
dhookom
tav1035
  • Locked
  • Question
access formula approach (RD workorders within 15 days of the closing of the last PM workorder)
Replies
1
Views
47
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top