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