Notification 1 month Prior to due date.

[Atchutaram]

Hi Everyone,

I have one requirement, we do have Services table and in that we do have Audit due, the user has to receive a notification one month before the due date, how can i do this, tried notification and gave the when to run condition as due date relative one month ahead, and its not working, how can i achieve this?

Best Regards

[Ankur Bawiskar · Accepted solution]

@Atchutaram 

you can use Flow Designer for this which runs Daily and checks if any records are there which are due 1 month from now. Iterate those and send email

check this link where I shared solution but please enhance it for your requirement

I cannot seem to get an Email Notification when a record's due date is reached 

filter condition will be something like this but this is for 10 days, you can enhance it for 30 days by updating the number of days in relative operator

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Atchutaram 

worth checking this as well

Flow Designer Demo: Automate Knowledge Expiration Warning 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Dr Atul G- LNG]

Hi @Atchutaram 

A flow-based design is best suited for this. Here are a few examples for reference:

https://www.servicenow.com/community/developer-forum/create-notification-for-kb-when-valid-to-is-1mo...

https://www.servicenow.com/community/servicenow-ai-platform-forum/how-to-send-a-notification-in-the-...