Relative date filtering on reports

Mahesh_Krishnan
Giga Guru

Hello:

I am trying to display records with a specific date field value between today and 15 days from now and am unable to do that using the Between or Relative condition options on the report.

There are more options when I use the filter options from the Report Administration menu but even there I do not see a filter for Next 15 days.

Two questions to the group:

1. How can I achieve what I am trying to?

2. Where are the pre-filter values generated from and can we create more custom values using scripts?

I show the values I can see from the report admin menu below:

find_real_file.png

Appreciate your thoughts and help!

 

Mahesh

6 REPLIES 6

sachin_namjoshi
Kilo Patron
Kilo Patron

You can use relative date filter like below

 

find_real_file.png

 

 

Regards,

Sachin

Sachin:

Thanks for your response. For some reason I am not getting the Days Ahead option, but I think you used 14 days "from now" option:

 

find_real_file.png

Also, you can use related operator like below

 

find_real_file.png

 

RRegards,

SSachin

But the above filter will give records with dates greater than 15 days from now. I want records between now and 15 days.