Incidents not updated for more than 10 Business(!) days

[Natalia S]

Dear colleagues, 

Please kindly help me to apply proper filter in order to track Incidents that have not been updated for more than 10 Business (!) days.

I am already using Operator RELATIVE: Updated RELATIVE before 10 days ago.

However, this filter returns INCs that were not updated for 10 days Including Weekends. 

What additional filter should i apply to see only those note updated for 10 Business days? 

P.S: i also saw a recommendation to apply TREND operator, but it looks like this is not what i need. Because when TREND applied in combination with Relative , i still see INC not updated for more than 10 days and not BUSINESS days.

Thank you so much in advance

[simonpullen]

Hey Natalia,

You could create a scripted date time and use it in a filter.

This article hopefully will help you:

https://community.servicenow.com/community?id=community_article&sys_id=7b5b60971b789010a59033f2cd4bc...

Regards,

Simon

[Natalia S]

Hi, i never scripted in SNOW - do i need to have specific role for this?

[Gaurav Shirsat]

 Hi Natalia

You can apply this filter

https://community.servicenow.com/community?id=community_question&sys_id=b6048be5dbd8dbc01dcaf3231f96...

Please Mark Correct and Helpful

Thanks and Regards

Gaurav Shirsat

[Natalia S]

hi, that's the combination of filters i started with.

but it does not actually work as expected, for example: today is Monday and i need to see tickets that were not updated for 5 days EXCLUDING weekends from calculation. The combination if filters you mentioned will pull tickets last updated on Wednesday. But the filter i need should find tickets that were last updated on previous Monday (thus, weekends excluded from calculation)