Hi Bear,

You would first load your DateDiff value as a number into a number variable. If it isn't, you wont see the Greater than/ Less than options. Then configure your RunIf like below:

Just be aware that the DateDiff is the difference between two dates. It will always return a positive number.

Cheers,

Mark

Mark,

Thank you for the response.  Question now is, using your capture, when I go to set-up the Run-If action, I do not get the same option which I have highlighted:

I am confused on where your are getting your information for Where?

Thanks!

He is using a Workflow variable.

You would have to declare one in your workflow (as a number)...

and then set it using a Set Variable action...

Alternatively, you could use the Math Operation action and then using the list lookup pick your list columns and then store it to a variable.

Hope this helps!

Additional to my previous question:

I got the following workflow to work and send me a the correct result:

Here is the Build String configuration:

Here is the Convert Value configuration:

1)  Why does the Build String only accept Single line of text Variable as shown below?  I tried other variations but it would not accept them.

2) Why does the above Variable show as RED in the Convert Value configuration?  Doesn't that denote an issue?

BTW - with this workflow that works, when I apply the same configuration into a large workflow and attempt to run it, I get the following error message:

Error parsing value. Value 'fn-DateDiffDays({ItemProperty:EffectiveDate},3/14/2016)' is not compatible with the selected output variable type Number (double).

Sorry for the large images, but I was afraid if I reduced them, they would be unclear to read and I am trying to get a handle on Nintex configuration without any prior workflow experience.

Bear,

1. Build String - it's in the name you are creating a string, so only strings can be output. This means that the "Store result in" variable needs to be a string.

2. All the red text means is that you have selected a reference and not typed text.

With your error, are you typing the date or is this simply what is being returned in the error after values are inserted?

Regards,

Mark

Mark,

Thanks for the clarifying the Build String! 

For your question, I am utilizing this string:

ItemProperty:Effective Date is the date the document was last approved taken from a Library.

Common:Current Date is today's date.

Example:     ItemProperty:Effective Date = 5/18/2015

                    Common:Current Date ===== 3/15/2016

                  (Variable)      Difference =====   302

I am using the string above and pulling the data in question, thus my confusion on the Variable:Difference  showing in RED.

Thanks!

Bear

Bear,

For your error - it appears that the value that is being passed through to your Convert Value shape is "fn-DateDiffDays({ItemProperty:EffectiveDate},3/14/2016)" and not the numeric value you would expect - for example "302" above. Did you insert the {ItemProperty:EffectiveDate} value from the insert references or was it typed in? That's about all I've got!

Cheers,

Mark

Mark,

I inserted the {ItemProperty:EffectiveDate}.  I try not to type any of the inline functions due to typos.  When setting up the Build String, it would only let me use a variable created with a Single line of text.  It would not recognize a variable with a numeric value.  Thus the use of the Convert Value action in the workflow.

I really appreciate your feedback on the whole situation - just trying to get a good handle of functionality!