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

[riaz_mansuri]

Thanks Chuck,

I tried this but I can't find the actual field in the tree:

No idea what it is trying me to show.

Any ideas how I can get to the actual field named Review Date

Thanks,

Riaz

[mazhar4]

Riaz,

Choose the option "a date/time field.." in the timer based on dropdown

[riaz_mansuri]

Hi Chuck,

Quick question on this. Can I trigger and Incident from a workflow?

Riaz

[Chuck Tomasi]

Hi Riaz,

You can create an incident from a workflow, if that's what you are asking. Use the "Create Task" activity and set the table to incident. Pretty simple.

Task Activities - ServiceNow Wiki

[riaz_mansuri]

Hi Chuck,

Thanks the reason I asked was because my workflow table was ast_contract. However, I achieved this now through the Run Script.

Thanks,

Riaz