Hi @ManishSolanki , This doesn't seem to be working as expected.
What I want is checking for weekdays only in below and exclude weekends .
less(item()?['Modified'], addDays(utcNow(), -1))
My whole filter array query is as below. I need to consider weekdays only when taking out days from AddDays function.
@or(and(equals(item()?['Progress'], 'Follow up with Customer'),less(item()?['Modified'], addDays(utcNow(), -7))),and(equals(item()?['Progress'], 'Refer to KYC'),less(item()?['Modified'], addDays(utcNow(), -3))),
and(equals(item()?['Progress'], 'Application form returned to BBCS'),less(item()?['Modified'], addDays(utcNow(), -2))),
and(equals(item()?['Progress'], 'Follow up with customer - Reminder 1'),less(item()?['Modified'], addDays(utcNow(), -4))),
and(equals(item()?['Progress'], 'Day 2/3 checks'),less(item()?['Modified'], addDays(utcNow(), -5))),
and(equals(item()?['Progress'], 'Sent to CAO'),less(item()?['Modified'], addDays(utcNow(), -5))),
and(equals(item()?['Progress'], 'Refer to Standard Legal'),less(item()?['Modified'], addDays(utcNow(), -5))),
and(equals(item()?['Progress'], 'Follow up with customer - Reminder 1'),less(item()?['Modified'], addDays(utcNow(), -4))),
and(equals(item()?['Progress'], 'Follow up with customer - Reminder 2'),less(item()?['Modified'], addDays(utcNow(), -7))),
and(equals(item()?['Progress'], 'Follow up with customer - Reminder 3'),less(item()?['Modified'], addDays(utcNow(), -14))),
and(equals(item()?['Progress'], 'Refer to RM'),less(item()?['Modified'], addDays(utcNow(), -7))),
and(equals(item()?['Progress'], 'Refer to RM – Reminder 1'),less(item()?['Modified'], addDays(utcNow(), -2))),
and(equals(item()?['Progress'], 'Refer to RM – Reminder 2'),less(item()?['Modified'], addDays(utcNow(), -2))),
and(equals(item()?['Progress'], 'Refer to RM – Reminder 3'),less(item()?['Modified'], addDays(utcNow(), -14))),
and(equals(item()?['Progress'], 'Refer to HRA'),less(item()?['Modified'], addDays(utcNow(), -5))),
and(equals(item()?['Progress'], 'Refer to MLRO'),less(item()?['Modified'], addDays(utcNow(), -5))),
and(equals(item()?['Progress'], 'Refer to FATCA NI'),less(item()?['Modified'], addDays(utcNow(), -1))),
and(equals(item()?['Progress'], 'Phonecall to customer required'),less(item()?['Modified'], addDays(utcNow(), -1))),
and(equals(item()?['Progress'], 'Pending with sig ver'),less(item()?['Modified'], addDays(utcNow(), -5))),
and(equals(item()?['Progress'], 'Pending with BFC'),less(item()?['Modified'], addDays(utcNow(), -1))),
and(equals(item()?['Progress'], 'Peer Review Approved'),less(item()?['Modified'], addDays(utcNow(), -1))),
and(equals(item()?['Progress'], 'Peer Review Rejected'),less(item()?['Modified'], addDays(utcNow(), -1))),
and(equals(item()?['Progress'], 'New Application Received'),less(item()?['Modified'], addDays(utcNow(), -1))),
and(equals(item()?['Progress'], 'Immigration Check Required'),less(item()?['Modified'], addDays(utcNow(), -1))),
and(equals(item()?['Progress'], 'Immigration Check Required'),less(item()?['Modified'], addDays(utcNow(), -1))),
and(equals(item()?['Progress'], '*** Onshore Referral Complete'),less(item()?['Modified'], addDays(utcNow(), -1))),
and(equals(item()?['Progress'], 'Onshore Referral'),less(item()?['Modified'], addDays(utcNow(), -1))),
and(equals(item()?['Progress'], 'Offshore Referral'),less(item()?['Modified'], addDays(utcNow(), -1))),
and(equals(item()?['Progress'], 'Offshore Referral complete'),less(item()?['Modified'], addDays(utcNow(), -1))),
and(equals(item()?['Progress'], 'Peer Review 2 Approved'),less(item()?['Modified'], addDays(utcNow(), -1))),
and(equals(item()?['Progress'], 'FOR ACTION - Customer Response Received'),less(item()?['Modified'], addDays(utcNow(), -1))),
and(equals(item()?['Progress'], 'FOR ACTION - Docs Returned to Branch'),less(item()?['Modified'], addDays(utcNow(), -1))))
