I have a problem with very basic workflow and need your help to troubleshoot it. I'm not sure if this is a design or system issue.
The workflow looks like this:
I have a document library which got an extra Date/Time column called Expiration where users will be typing an expiration date of a file. The first workflow should send them notification one day before this date and the second one should delete the file.
I set a variable called ReminderDate (date/time type) to store the calculated date. The calculation looks like this:
and the Pause until... control is set like this:
The workflow is still in In Progress state even after the expiration date... It holds on Pause Until... and won't get further.
I tried to lookup the column, but it also does not work:
I found those two topics, but the solution does not work for me:
I have a list that has fields for certain items with expiration dates. I'm suppose to build a workflow that will have to cleverly calculate the due date for an item - 20 days before they expire and generate a notification to an assignee notifying them of
Thanks in advance!