Send a reminder email before End date is due

[WaledBajukhaif]

We have a request to create a field "xyz" to enter number of days in [ast_contract] table, this field will count how many days left to "End Date" field. then send a notification/reminder to "Manager" field.

Ex: a contract end date is "31/12/2028", i want to send a notification/reminder to the manager 6 months (or X months) before 31/12/2028. which means i would enter "182" (this is number of days ~6 months) in "xyz" field.

When current date is "01/07/2028" send a notification. (because it's 182 days left to End date).

Any help/suggestion would be helpful

Regards

[Dr Atul G- LNG]

Hi @WaledBajukhaif 

https://www.servicenow.com/community/developer-forum/use-due-date-in-flow-designer/td-p/2712296

https://www.servicenow.com/community/itsm-forum/need-to-trigger-notification-using-flow-designer-on-...

[WaledBajukhaif]

Thanks Dr,

these links are close to achieve my request if the number of days is set for all contracts.. but my request is every contract reminder is different than the other.

[Dr Atul G- LNG]

Hi @WaledBajukhaif 

Do you have some kind of flag in the contract table that indicates how two contracts are different? If yes, then we can use that flag in Flow Designer to implement the same logic we discussed earlier.

[WaledBajukhaif]

Not sure what you mean by flag,, but all contracts have end date field.

Scenario:

Contract A end date is xx/xx/2028

Contract B end date is xx/xx/2029

Contract C end date is xx/xx/2027

let's say i want send a reminder to the manager for:

contract A 6 months before end date

contract B 4 months before end date

contract C 1 month before end date

I'm thinking to create a "Date" type field in [ast_contract] table to enter a date, and create a flow runs daily to check this "Date" field, once date = current date > send a reminder!