Rolling Date Filter

[matix10]

Hi All,

I want to apply rolling last 3 years data filter in my report. I have gone through the available threads and tried to implement it but not able to get the expected result.

I have to rolling filter data from current date to last 3 yrs data. Can somebody please help me with this?

Thanks in advance!

[matix10]

Hi amit.kumar71 ,

Could you please help me with this ?

Thanks in advance 🙂

[amitrathi239]

what is the backend database?

[matix10]

Hi amit.kumar71 , It is oracle database

[amitrathi239 · Accepted solution]

Create variable like 3Yr back date=RelativeDate(CurrentDate();-3;YearPeriod)

Final variable=If ([your date object] between ([3Yr back date];currentdate()) then "Show" else "Hide"

Apply the filter at Table where equal t Show

[matix10 · Accepted solution]

Thank you amit.kumar71 for your help as always! 🙂