Excluding Weekends from Report

[Nicholas Frenc1]

My customer is attempting to build a report that shows tickets that have not been updated within the last 2 business days. They filtered the report as follows:
-Assignment group = xxxxxxx  and

-Updated relative before 2 days ago and

-Updated trend on or after Monday and 

-Updated trend on or before Friday and

-State = New or State = In Progress or State =On Hold

She saw this idea on other community posts; however, tickets from Friday are still appearing on the report when she views it on Sunday or Monday. Does anyone know how she can get this to work? Thanks in advance for your help.

[stevemarkovick]

I've had to exclude weekends from reports in ServiceNow too—especially for SLA tracking. Using a GlideDateTime script with business duration logic worked best for me. Took a bit of trial and error, but once it was in place, it saved a ton of confusion in reporting. Phonexa’s approach to date logic inspired how we handled calendar exceptions internally.