Send email notification when "Planned end date" is one week passed

[Saranya2]

Hi All,

->I need to trigger a email notification on change task table, when planned end date is one week passed (Excluding weekends) & if state is "In Progress".

-> The 2nd notification will be triggered on the next day if the state is still "In Progress".

-> The 3rd notification will be triggered on the next day if the state is still "In Progress". (Final remainder)

Can anyone help on this?

Thanks,

Saranya

[Ankur Bawiskar]

@Saranya2 

So what did you start with?

[Saranya2]

Hi Ankur,

I have created a Scheduled job as below, But I am not sure how to exclude weekends. Can you check once?

[Ankur Bawiskar]

@Saranya2 

you can add 7 days to planned date excluding weekends

check this link

Add Business Days 

[Community Alums]

You can achieve this via a scheduled job. Create an event in event registry. Create a notification with the trigger as an event is fired and then use this event in a scheduled job using gs.eventQueue()