cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
pjnshelly
Nintex Newbie

Expiration Date Alert

Jump to solution

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.

Labels: (2)
0 Kudos
Reply
2 Replies
Automation Master
Automation Master

Re: Expiration Date Alert

Jump to solution

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

View solution in original post

0 Kudos
Reply
pjnshelly
Nintex Newbie

Re: Expiration Date Alert

Jump to solution

That worked like a charm.  Thank you.

Reply