Supress all but last 3 months

[ddnh]

I have created a chart in the footer of a group based on a date field. Right now it prints for every month for which there is data. I'd like to suppress all but the current month and the previous two. Any suggestion on the formula I should use in the Section Expert Suppress x+2 field?

If the report is run today it should only show the chart for April, March, and February.

 

[mbarron]

The datediff function should do it for you.

For your supression formula use:
datediff("m",{date.field},currentdate)>2

Mike

 

[ddnh]

Perfect! thank you.