Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to Fetch Sctask Records based on last updated Exclude Weekends

harinya
Tera Contributor

Hi 
Can you please some one help,

I have Requirement to fetch Sctask records where last updated is past due of 3 days ago excluding weekends
I have used the Relative condition to get updated relative before 3days ago and it fetching the Records but in calculation's it considering the weekends i want to exclude week end(Saturday and Sunday) and consider only weekends can you please help me to get this filter conditions i am using Tokyo version.

 

Thankyou

 

5 REPLIES 5

maroon_byte
Mega Sage

Try using the 'trend' operator. But this does not consider holidays.

 

maroon_byte_0-1711989999291.png

 

Regards,

Sharad

 

I have already Tried but it 's not working

maroon_byte
Mega Sage

What is the expectation after fetching the records... Notification, reporting, etc.?

Just for Reporting Purpose to show in Dashboard