We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

How to exclude weekends from report condition?

Reddy
Kilo Sage

Hello,

We are pulling reports on Incidents that are not updated for 5 days and we would like to see only the Incidents not updated for 5 days ago excluding weekends.

Thanks,
SR.

2 REPLIES 2

Onkar Pandav
Tera Guru

Try applying below filter condition.

Updated - relative - before - 5 days from now   AND

Updated - trend - on or after - Monday    AND

Updated - trend - on or before - Friday

 

find_real_file.png