G Guest Mar 8, 2007 #1 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
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 Mar 8, 2007 #2 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
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 Mar 8, 2007 #3 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.
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.
G Guest Mar 8, 2007 #4 Thanks fredg and Doug It works great. I wasn't using Now in my in my date query. Ron
