How to use use "Relative" condition for reporting

Ceci Looi · ‎04-18-2023

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 · ‎04-19-2023

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.

View solution in original post

Kamil Smusz · ‎04-19-2023

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 · ‎04-19-2023

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