Date Range

[btamulis]

I have a report where I want to use select expert to define report date range -
I want report to look only at records with a date up to 30 days prior from now and 365 days forward.

I tried the follwoing formula(s):

{TEC_SALESFORECAST_QTY.DATE1} in (LastFullMonth)or(Next91To365Days)

{TEC_SALESFORECAST_QTY.DATE1} in (LastFullMonth)to(Next91To365Days)


these did not work - I do not want to use parameters - i simply want report to filter - 30days prior and 365 days forward

thanks in advance for any assistance.........

Bron Tamulis, CPIM
Great Plains Mfg Consultant

 

[mocgp]

Try
{TEC_SALESFORECAST_QTY.DATE1} in
CurrentDate-30 to CurrentDate+365

 

[btamulis]

thanks a bunch......works great

Bron Tamulis, CPIM
Great Plains Mfg Consultant