Obtaining data from current month + 90 days 1

[crystalhelp1]

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.

 

[lbass]

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

 

[crystalhelp1]

Thanks! Worked perfectly!!