cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Problem with Pause Until and calculating the proper date

Jump to solution

Hi everyone!

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:

Screenshot - 2016-08-10 , 16_33_50.jpg

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:

Screenshot - 2016-08-10 , 16_34_23.jpg

and the Pause until... control is set like this:

Screenshot - 2016-08-10 , 16_35_09.jpg

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:

Screenshot - 2016-08-10 , 16_35_59.jpg

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 workfl...

Nintex Reminder, need to send reminder according to days left.

How do i initiate email reminder 30 days from the date in a field?

Thanks in advance!

Artur

Labels: (2)
0 Kudos
Reply
11 Replies
jesse_mchargue
Nintex Newbie

Re: Problem with Pause Until and calculating the proper date

Jump to solution

Artur Siwakowski​ -

Add a Log to history action right after your calculation and output the calculated variable (ReminderDate) to confirm that it is accurate.

Hope this helps!

Reply
Not applicable

Re: Problem with Pause Until and calculating the proper date

Jump to solution

Hello Jesse McHargue

I've added the Log History as you adviced and it helped a lot! I modified the workflow a little bit by adding the Query List control:

Screenshot - 2016-08-10 , 19_39_45.jpg

I configured it to store the column value in variable:

Screenshot - 2016-08-10 , 19_40_05.jpg

Thanks to your advice, I noticed that the value queried from the column is different that the one that is set. Example: I set the column to 2016-08-13, but the workflow sees it as 2016-08-12

Screenshot - 2016-08-10 , 19_38_22.jpg

Screenshot - 2016-08-10 , 19_38_44.jpg

I need to check why it's not queering the correct date...

Reply
jesse_mchargue
Nintex Newbie

Re: Problem with Pause Until and calculating the proper date

Jump to solution

Artur Siwakowski​ -

If you are running the workflow on each item upon creation, there is no need to query the list. Simply do your date calculation in the current item, like so:

Since you are using a Query List action, it is taking ALL ITEMS in your list and storing the first one (I am assuming it is ordered by ID, so it is taking ID: 1). This makes sense if you look at your log because it is saying your expiration date is 8/12/2016, which is the date for ID: 1.

You can simplify most of it with this:

Here is a sample run:

This should clear up your issues and get you going!

Hope this helps!

Reply
Not applicable

Re: Problem with Pause Until and calculating the proper date

Jump to solution

Jesse McHargue

I disabled the Query List and first Log. Also changed the calculation as you suggested:

Screenshot - 2016-08-10 , 20_25_08.jpg

I think there might be something wrong with the site collection settings, because when you take a look a the item ID 6, you will see that it has the File Expiration column set to 2016-08-13, so it should calculate the date of 2016-08-12, but when I look a the log, I see it set the reminder on 2016-08-09 and also sent me an email with old date:

Screenshot - 2016-08-10 , 20_25_41.jpg

Screenshot - 2016-08-10 , 20_26_01.jpg

On the other hand, the regional settings look ok. The time zone is set to UTC+1 :/

Reply
jesse_mchargue
Nintex Newbie

Re: Problem with Pause Until and calculating the proper date

Jump to solution

Artur Siwakowski

Check your variables, it looks like you are pulling in Created or Modified date rather than the File Expiration.

Hope this helps!

0 Kudos
Reply
Not applicable

Re: Problem with Pause Until and calculating the proper date

Jump to solution

Jesse McHargue

The variable I'm using is set to Blank:

Screenshot - 2016-08-10 , 20_47_06.jpg

So it can't be it

0 Kudos
Reply
jesse_mchargue
Nintex Newbie

Re: Problem with Pause Until and calculating the proper date

Jump to solution

Hmmm... Not sure then. Are you able to export the workflow and then attach it here? I can load it up in a virtual machine and take a look.

0 Kudos
Reply
Not applicable

Re: Problem with Pause Until and calculating the proper date

Jump to solution

Here you go! Much appreciate your help!

This is a standard document library with one additional column:

Screenshot - 2016-08-10 , 21_13_19.jpg

Reply
jesse_mchargue
Nintex Newbie

Re: Problem with Pause Until and calculating the proper date

Jump to solution

AH There it is.

Are you able to change File Expiration to have no default value?

It is causing the workflow to use the default value and not the updated one.

Examples:

With DEFAULT date:

With NO DEFAULT date:

Try that and see if that resolves your issues.

Reply