Skip to main content

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.

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


That worked like a charm.  Thank you.


Reply