I am trying to create a filter using select expert which shows only the records with an {Order.FilledDate} in the month which was four months ago.  I want to be able to run this report each month without adjusting the parameters (my colleague runs it and doesn't like the formula side)

 

EG it is now December so I wish to show all records with a filled date in August.

 

I can run the report with ({Order.FilledDate} in CurrentDate -120 to CurrentDate -90) but this isn't quite what I need.

 

I want if current date xx/12/10 then show records with filled date xx/08/10 then in january it would be xx/01/11 and show records filled xx/09/10

 

Any assistance would be greatly appreciated.

 

Regards,

 

bowja