Relative filter condition for a report

[sndev1099]

Hi, 

I have a report set up but it doesn't seem to be working as I want it to. I think it's because I haven't used the relative filter condition correctly. I need it to display users that have an end date that is in the last 2 months from today. Can someone point me in the right direction?

[sndev1099]

Hi Jency. That's showing the end date in the future though? I need mine to be in the last 2 months from today. I'm still getting users with an end date as 1st Feb 2020 which is longer than 2 months ago. There shouldn't be anyone showing up in the report with an end date earlier than the 8th of Feb.

[Jaspal Singh]

In that case use 'at or before' instead of 'relative'.

Thanks,

Jaspal singh

[Jan Cernocky · Accepted solution]

How about this one?

If you want to have users with end date between 2 months prior today and today, set it in between these 2 conditions...

[sndev1099]

That's the one 🙂 Thanks a lot

[sndev1099]

Hi Jency. How about if I wanted to do it the other way? So I need it show users that have an end date from today up until 2 months from now.