Have email notification on the 1st date of each month to group for contracts which reach or over expiration condition. (180 days expiration date)

[sudaporn]

I want the system to send email when contracts reach or over expiration condition     , The email will notify everyone in group. For example , contract ends on 30/12/2017. For example , contract ends on 30/12/2017. Notification condition is 6 months before end date. So the system should send notification from 1/6/2017 ,1/7/2017, 1/8/2017.... until the contract is renewed or extended.

Now I used condition checks within 180 days and used "Contract Threshold breached" on notification

>> I want to email notification on the 1st date of each month (within 180 days)     How I config this.

[sudaporn]

Please you check that picture below , I config , Do you think it all right ?

[Deepak Kumar5]

Change the querystring from code to actual query.

open user table in list view and apply the filter as per your requirement. Run the filter then copy the query from there.

[sudaporn]

[Deepak Kumar5]

use encoded query as string.

var strQuery = 'active=true';

gr.addEncodedQuery(strQuery);

[Prasun]

Hello Sudaporn,

Run a Schedule script daily 00hours and check the day difference between contract expiry. if the difference is 180, 150,120,90... then fire the event.

Based on event, trigger the notification.

Hope it helps.

PS- please hit like or mark as helpful if helps.

Thanks

Prasun