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!

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

Obtaining data from current month + 90 days 1

Status
Not open for further replies.

crystalhelp1

Technical User
Aug 21, 2010
19
US
I need to capture the quantity field of all dates in this month and all dates out 90 days. The problem is, I can't figure out how to grab the quantity field of the dates already passed in the current month.
 
There is a function monthtodate, but if I'm following, you could use:

{table.date} in date(year(currentdate), month(currentdate),1) to currentdate+90

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top