Exlcuding Weekends from being counted on a report

LiamB
Tera Contributor

Hi all! 

Part of our internal process is to identify what cases have not been updated for 3 days to ensure communication and pressure is applied to resolve. 

I have worked out how to show the counter for cases to not be updated for 3 days but on a Monday, this takes into consideration Saturday and Sunday which are not business working days. Is there an easy fix to apply to exclude Saturday and Sunday? 

We also have a report to show what is due to be followed up called ' Tomorrows diary ' but obviously on a Friday it is set to ' tomorrow ' which is not a buiness day and the next day is Monday, is this something that can be excluded modified to help? 

Thanks in advance for all your help 

7 REPLIES 7

Hi @LiamB 

 

Trend is only option, if it did not work, you can log a now support case. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hi @Dr Atul G- LNG  how do you log a support case sorry? Never done it before.

 

Thanks in advance

To log a support case, you need access to the support portal, which is accessible either through your official ID or available to your customer only.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************