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

Brasa · ‎07-10-2023

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 · ‎07-11-2023

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

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

Brasa · ‎07-12-2023

Thank you very much! It works like a charm!