Send email notification when date is reached

[riaz_mansuri]

Hi,

I want an email to be sent when a specific date field has reached 30 days before the actual date.

I have set this on the contracts table but is it not working, does anyone know a script I can use?

The field is a date field called u_review_date

When this is less than 30 days away and email notification should be triggered.

Any ideas?

Thanks

[Chuck Tomasi]

I'm glad you got it resolved.

[ritaaudi]

Hi Chuck: I have an itil user in my organization that wants to schedule an email for an incident to be sent on a specific date. Is there an easy way for an itil user to do so themselves without me scheduling a job for them? Thank you. Rita

[Chuck Tomasi]

Hi Rita,

If you are using a scoped app, you can use delegated development (Helsinki and above) to allow non-admins the ability to send a notification. If it is scheduled (runs once a day at 2:00AM for example) that still requires admin privileges.

[ritaaudi]

Hi Chuck: I think this will give them too much power. I simply want them to add a comment but have it scheduled to be sent on a future date. No such a thing, huh? Thx

[Chuck Tomasi]

Hi Rita,

Just so I understand completely... can you elaborate on what you are trying to do? I seem to have gotten requirements a bit mixed up on this one. They could enter a date and your scheduled job can check for records that match the criteria (e.g. date is <= to now and no notification has been sent.)