Last three months Filter - Help me!

[lorenmario]

Hello!

I am creating a report using a relational database. I need to insert a filter that I will always return the last three months from the current date.

How to do this in Report Studio?
Thank you!!
;)

[Lynn]

Create a filter with this expression:

[YourQueryItemDate] >= _add_months(current_date, -3)

[Web2CRM]

Try the expression below in your filter:

[DataItemDate] between _first_of_month( _add_months(current_date, -3) ) and current_date

[lorenmario]

I will test here, thank you!!