Relative filter condition for a report

sndev1099
Giga Expert

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?

 

find_real_file.png

1 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...

find_real_file.png

View solution in original post

11 REPLIES 11

Jaspal Singh
Mega Patron

Hi,

 

Nothing wrong with the filter. What is the issue?

 

Thanks,

Jaspal Singh

RudhraKAM
Tera Guru

find_real_file.png

 

Use this , this will give you last 60 days records (ignore work end , instead select ur field)

The screenshot looks like pre-New York version, the settings are different in NY

Jan Cernocky
Tera Guru

Works well at my end, what's the issue?

 

find_real_file.png