cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

"Convert Value" action item errors out repeatedly

Jump to solution

I have tried multiple variations of date formats in the Nintex Workflow "Convert Value" action item.  However, I have had no success.  Here's one sample of what I have been working on:

Configure Action - Convert value

StartDate is a variable with a value of "2017-09-11T13:00:00Z".  The contents of the StartDate variable is to mimic the date information that is pulled out of a web request (Exchange out of office).  I've created a smaller workflow in order to work through the issue with the "convert value" action item.  Essentially, what I'm looking to do is to convert the string value of StartDate to a date data type. When I run the above action item, these are the results I see.

Error text

I've added a time format, too, to see if that would help but had the same results.

More error text

I've tried various other format strings with the same results.  What could I be doing wrong?  Any help would be much appreciated!

0 Kudos
Reply
5 Replies
Workflow Hero

Re: "Convert Value" action item errors out repeatedly

Jump to solution
0 Kudos
Reply
Workflow Hero

Re: "Convert Value" action item errors out repeatedly

Jump to solution

I had visited that message prior to posting my own but I didn't have any success, unfortunately.

0 Kudos
Reply
Workflow Hero

Re: "Convert Value" action item errors out repeatedly

Jump to solution

ok.

so let's try:

- remove culture

- and use following format string: yyyy-MM-ddTHH:mm:ssZ

‌ string to date‌

0 Kudos
Reply
Workflow Hero

Re: "Convert Value" action item errors out repeatedly

Jump to solution

I had tried that format string previously but with one significant difference - I used uppercase.  When I copied/pasted your string exactly, it worked!   Thank you!

Reply
Highlighted
Workflow Hero

Re: "Convert Value" action item errors out repeatedly

Jump to solution

small or capital letter, that makes a difference in date format string.

see this reference  

Reply