Need Date formula

R

Ron Weaver

What kind of formula would I need in the date field of a query to pull the
next 5 days of orders, including today?
Thanks
Ron
 
F

fredg

What kind of formula would I need in the date field of a query to pull the
next 5 days of orders, including today?
Thanks
Ron
Click to expand...

5 days including today?

Between Date() and Date() + 4

If you meant today and 5 days after today
Between Date() and Date() + 5
 
D

Douglas J. Steele

fredg said:
5 days including today?

Between Date() and Date() + 4

If you meant today and 5 days after today
Between Date() and Date() + 5
Click to expand...

Note, too, that if your Date field also includes Time (because you used Now
rather than Date to populate them), you'll need to add one more than Fred
indicated.
 
R

Ron Weaver

Thanks fredg and Doug
It works great.
I wasn't using Now in my in my date query.
Ron
 
Top