alexviera
Rookie

Re: Converting a string to date variable in NWC workflow

Hi, 

 

Can you publish a new export key? Thank you.

0 Kudos
Reply
alexviera
Rookie

Re: Converting a string to date variable in NWC workflow

The NWC toolkit has an action (Convert String to Proper) 

that will do this conversion.

 

https://community.nintex.com/t5/Blog/NWC-Toolkit/ba-p/213241

0 Kudos
Reply
WouterT
Contributor

Re: Converting a string to date variable in NWC workflow

@alexviera that is good to hear. I'll try the toolkit.

Just in case,  here is the export key: Qsgj5mxy3P9fjXQUiPpcFsNhM25U3gF4nDu3ezuMSANQcZBb8

0 Kudos
Reply
alexviera
Rookie

Re: Converting a string to date variable in NWC workflow

Sorry, it was expired One more time please.

0 Kudos
Reply
WouterT
Contributor

Re: Converting a string to date variable in NWC workflow

jtjcojq3X7U2d872ot7Upn4MSciDuvHR3x1muXWpZyjgrzxbk at your service.
Reply
WouterT
Contributor

Re: Converting a string to date variable in NWC workflow

As @alexviera already noted: please use the NWC Toolkit instead. Easier, better, quicker.

Link to the NWC Toolkit page.

0 Kudos
Reply
WouterT
Contributor

Re: Converting a string to date variable in NWC workflow

Just tested the NWC Toolkit: all works fine... except... for the date formatter.! Also the NWC Toolkit DateFormatter is an action to convert a date into a string but not the other way around: a string into a date. And that's what we're looking for.

So, I guess you're all back to my (clumsy but workable) solution for now. See also comments on : https://community.nintex.com/t5/Blog/NWC-Toolkit/ba-p/213241

I'll post an update soon with a more simple DIY step by step.

 

0 Kudos
Reply
WouterT
Contributor

Re: Converting a string to date variable in NWC workflow

Here is a special post on how to DIY convert a date in text to a date variable.

0 Kudos
Reply
alexviera
Rookie

Re: Converting a string to date variable in NWC workflow

Ok, maybe I'm missing something. If you take a string date "7/10/2022" and want to convert it to a datetime you call Convert String to Proper, isn't that what you are trying to do?

 

 

Reply
WouterT
Contributor

Re: Converting a string to date variable in NWC workflow

Well done @alexviera ! Kudo well deserved.

The documentation of the toolkit is so brief that I overlooked it. Probably also not realizing the proper meaning of  the word "to Proper".

Took me a while to figure out that the result variable has to be defined as a date variable within the NWC Toolkit section (and not as a workflow variable):
2022-07-27_12-29-40.png

Secondly, the input string has to be in the right format: in my case mm/dd/yyyy. Probably my regional settings. Otherwise it results in this error:

2022-07-27_12-17-51.png

But if that is not an issue: Yep, it works.

0 Kudos
Reply