Expiration Date Alert


Badge +3

I set up a nintex workflow to trigger off a calculated field of 30 days prior to an expiration date that was entered by a user.  The calculated field formula was =text(ExpiredDate - 30,"mm/dd/yyyy").  I used a "Pause until" action.  The workflow doesn't pause until that date.  It triggers off like 5 mins after I start the workflow, even though that date that it should trigger off should be tomorrow for testing. 

When I look at the workflow, it shows that it will trigger off on "Pausing until 1/1/0001 12:00:00 AM".  Any thoughts on what I am doing wrong.


2 replies

Badge +16

you can't use calculated columns in this way with workflow.

You could as an alternative use "calculate date" to calculate 30 days before and then pause until then (utilising a date variable).

or you could schedule a site workflow like this

Badge +3

That worked like a charm.  Thank you.

Reply