Report changes between this week's Tuesday and next week's Monday

[Brasa]

Hi, folks!

I need to create a report in ServiceNow that dynamically displays all changes scheduled between this week's Tuesday and next week's Monday. I tried to play around with the "trend" and "relative" operators, but could not come up with something that displays only this range. After all, it's not "this week". Any ideas? 

[AndersBGS · Accepted solution]

Hi @Brasa ,

you should be able to create a report with the conditions:

schedule on this week and

S schedule  relative after Tuesday 

OR

schedule on next week and

schedule relative before Monday 

its important to have the big OR i between the two conditions, otherwise it will not work .

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[RalfW]

Hi Anders,
I just came across this post after a very long google search. I've got a similar yet slightly more complicated question, maybe you can help me as well.

Our CAB is always on Tuesday from 13:30 to 14:30, so I would need to create a report showing me the Change Requests for one week after the CAB has ended, so basically from one week on Tuesday after 14;30 until the following week Tuesday 14:30.
Do you know if something like this is even possible with regular reports? I haven't found any solution so far.
Best regards,

Ralf

[AndersBGS]

Hi @RalfW ,

Which field store the date value there should be between this week Tuesday 14:30 --> next week Tuesday 14:30. 

[RalfW]

Unfortunately that did not help because there is no possibility to chose something like "this week Tuesday". I can chose "This week", but there is no option to further chose a specific day of the week and then the time, neither for the start nor the end. There is one option called "Days", but this only shows something like "Today", "Yesterday", "Tomorrow", "Last 7 days", etc., so these options do not help at all I'm afraid. Und "Weeks" I can chose "This week", but again the day of week and the time is missing and there seems to be no options to select it correctly.