Last 3 months (UG!)

[goldfishhh]

I'm beating my head against the wall on this one. I want to run a report during a month and have the date range be "past 3 months".

Help computer!

 

[satinsilhouette]

Try this:

if {datefield} in DateSerial(Year({?Start Date}),Month({?Start Date})-3,01)
to DateSerial(Year({?Start Date}),Month({?Start Date})-2,01-1)

Thanks so much!
satinsilhouette

 

[lbass]

Try using a record selection formula like this:

{table.date} in dateadd("m", -3, currentdate-day(currentdate)+1) to currentdate-day(currentdate)

-LB