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

[Dhananjay Pawar]

Hi,

Here is the filter.

gr.addEncodecQuery('sys_updated_onDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','EE')^ORsys_updated_onDATEPARTTuesday@javascript:gs.datePart('dayofweek','tuesday','EE')^ORsys_updated_onDATEPARTWednesday@javascript:gs.datePart('dayofweek','wednesday','EE')^ORsys_updated_onDATEPARTThursday@javascript:gs.datePart('dayofweek','thursday','EE')^ORsys_updated_onDATEPARTFriday@javascript:gs.datePart('dayofweek','friday','EE')^sys_updated_onRELATIVELT@dayofweek@ahead@10');

Thanks,

Dhananjay.

[Ankur Bawiskar]

@Natalia S 

Since you require 10 business days you will have to use Schedule during the calculation and use script include call in the report

Refer below link for help

Not updated in Last 5 days

Regards
Ankur

[asifnoor]

Hi,

Find the below article where you can check for business days.

https://community.servicenow.com/community?id=community_article&sys_id=4c66ff4a1bde08107a5933f2cd4bc...

Mark the comment as a correct answer and helpful if this helps.