Skip to main content
Nintex Community Menu Bar

Expiration Date Alert

  • July 10, 2017
  • 2 replies
  • 36 views

Forum|alt.badge.img+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

Forum|alt.badge.img+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


Forum|alt.badge.img+3
  • Author
  • July 10, 2017

That worked like a charm.  Thank you.