Script Help to exclude weekends

[Jyoti Tripathi]

I have a custom True/False field, i wanted to make the field set as true when the Assignment Group for the case is empty for more than 1 business days..
Someone please help how to achieve this

[Jyoti Tripathi]

Table is sn_hr_core_case and field name is assignment_check1bd
This is how i want this to work-
if the case got created on Monday and group was empty.. so on Tuesday(More than 1 business days) it will make the field set as true
if the case got created on Tuesday and group was empty.. so on Wednesday..it will make the field set as true.. and so on..
But if the case got created on Saturday/Sunday and group was empty.. so on Tuesday (More than 1 business days) it will make the field set as true

[Ankur Bawiskar]

@Jyoti Tripathi 

you can schedule job daily and check if the group field is empty and it has been more than 1 business day

business day calculation is already shared with you

[Jyoti Tripathi]

Hi @Ankur Bawiskar : Apologies, i am not able to see the calculation shared by you.

[Ankur Bawiskar]

@Jyoti Tripathi 

calculation is shared by other members.