I am trying to assign a SharePoint date field to a Nintex variable. I know that there is a date in the SP field, but after I try to set the variable I get the "null" date value. Here are the values from the history list.
NextWednesday (field from list) = 03/28/2018
varWednesday (the WF variable I've tried to set) = 1/1/0001 12:00:00 AM
Can anyone tell me how to overcome this? Seems this ought to be pretty simple, so I must be missing something.
Solved! Go to Solution.
How do you assign the Date column to the wf date variable? Mostly I use the Set Variable action and the List Lookup to the current item, or it is set in a List Query.
If neither applies, you could try using the Calculate Date action (all parameters 0) to transfer the Date column value to the date wf variable.
The problem is that I was using a calculated column that I believe was converting to text. So I just convert the result back to date/time and all is well!