Exlcuding Weekends from being counted on a report

[LiamB]

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 

[Dr Atul G- LNG]

Hi @LiamB 

Try this condition in date filter:

[LiamB]

Hi Tera 

Thanks for your reply, is the filter on or after Monday and on or before Friday? or the other way round? 

Will try it for this weekend! Thank you for your help

[Dr Atul G- LNG]

No mate, that is the best option we can follow. You can put hours/month and year too instead of days.

[LiamB]

This was not resolved unfortunately....

Would we have to exclude business days somehow?