I have a Change Request report that uses the Relative filter for all changes with a Start Date and time in the next 7 days. Is there a way to ignore the actual time of the Change Request.
So for example, if I run the report at 10:00am, it will show me all of the changes for the next seven days up until 10:00am. So it won't show me the change scheduled at 7:00pm on that seventh day.
If I run the report on 5/21/2015 I want it to show me all the changes that start on 5/21-5/28 regardless of time of day. Any ideas?
i have a similar issue. Suppose i run the below query to get incident tickets resolved on Yesterday, i get the total as 270 tickets.
Whereas if i run below query, i get 270 ticket. This value is correct for my purpose where i want 3 days data every Monday (i.e. Friday thru Sunday data).
It seems Relative filter with Days takes value as (number of days) x (24 hours), whereas it behave like the "Yesterday"/"Last Month" condition.
We are having the same issue, I have a job that needs to send out email for anything created ON 25 days ago, however, it returns no results. The above query is the only thing that seems to get the data I need but is not intuitive to any normal business user. I would expect "ON" to be anything on that day.
