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. 

[Rakeshlal KJ1]

Hello @AndersBGS ,

I am facing the same kind of challenge here, can you put a screenshot of the filter condition which have explained above,  Since am unable to implement those in my ServiceNow,
My requirement is the planned start date should be from Monday to next Tuesday and I will be scheduling the report on every monday morning 8 AM. 
I have pasted the filter condition which I have tried after reading your answers, but I am sure am clearly missing something here.