Report using relative condition but omitting weekends

[bryanc78]

I'm looking to run a report that shows me all cases that have not been updated within the last 5 business days.  Obviously, if I run this report on Monday I have to deal with the weekend.

So, If I run the report today, 3/27, I should only see cases that were last updated  3/19 and earlier.  Is there a way to exclude weekends this way?

[Jar]

Hi Bryanc78,
Checkout this post regarding the same request.

Solved: Exclude weekends from report condition - ServiceNow Community

[bryanc78]

I did see that but it's not working for me

When I use this condition, the record with the most recent Updated date is 3/22.  Not 3/20

[AndersBGS]

Hi @bryanc78 ,

I think you should be able to utilize a filter stating: not updated relative after 7 days ago, as there will always be 2 day weekend in between… so 5 days ago plus the weekend 2 days ago = 7 days ago.

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

Best regards

Anders

[bryanc78]

That will work for something like 5 days.  But if I wanted to do say 2 days to look at my critical cases, excluding weekends, it will not work.

Guess I'll just keep updating my dates as needed