I want to exclude weekends and holidays for a report in Servicenow.

[Harsha Pandey]

Hi,

The requirement is I want a report that has not been updated since 7 days excluding weekends and bank holidays.

For the weekends I have applied below filter in the report but for bank holidays how can we include the schedule entry.

sys_updated_onRELATIVELT@dayofweek@ago@7^sys_updated_onDATEPARTMonday@javascript:gs.datePart('...

Please suggest.