How to use use "Relative" condition for reporting

[Ceci Looi]

Hi. I am trying to run a report showing daily IMS count for the past 20 days. I am using relative condition. However the data is not showing the correct time-frame. I am expecting to see data between March 30 up to April 18 (Today). I have tried different criteria and the only right data I am seeing is when I use "Opened relative after 10 Days ago". 

Any other X days will give me wrong date. 

Can anyone guide me how to fix this?

 

[Kamil Smusz · Accepted solution]

hi @Ceci Looi 

Are you sure that Type is not the issue? I checked on sc_task table and relative after x days ago works fine for me.

[Ceci Looi]

@Kamil Smusz  Thanks for verifying. I have received a note from my internal support team that it is a bug. A case has been filed to ServiceNow. I'm not sure if this bug is widespread of limited to my organization.