Converting a string to date variable in NWC workflow

[Gavin-Adams]

I have a component workflow that is receiving dates as a string variable.

The dates are supplied from another web service that is only exporting text strings.

The dates are formatted 'yyyy-mm-dd'

I want to convert this to a date variable in NWC.

I have a variable txtFromDate (text) and dateFromDate (datetime).

I tried set a variable action but the variable types are not supported.

Any ideas on this?

[Sven]

Hello @Gavin-Adams , 

at the moment, this is not possible in standard -

Please have a look at our roadmap, we will implement this feature this quarter.

https://community.nintex.com/t5/Roadmap/Nintex-Product-Roadmaps/ba-p/94755

[WouterT]

Any update on this? As per today (27-May-2022) I cannot seem to find anything that supports this nor see it anywhere anymore in the roadmap.

[anissa_divincen]

I'm needing to do the same.  Any update on the implementation of this?

[Sven]

Hi everyone,

thanks for the patience, we will check with the product managers and get back to you soon.

regards

Sven

[WouterT]

OK @Gavin-Adams and @anissa_divincen .

Here is the most ugly workaround you've probably ever seen. More just for the fun of it. I just couldn't cope with 'no' for an answer 😉

A component workflow that transfers any format of a date into a date var. Hope it works for you.

Here is an export key for the component workflow (valid until June 13): QWjRqAHSScRdnLhWZcVd4GLgWzERnDM5JuWpy51ghvzi5LmfG

If you need another export key, drop a reply and I'll provide it.

The format input par is by default (if empty) yyyymmdd

But you might also specify anything else that has yyyy, mm and dd strings in it. Such as dd-mm-yyyy or mm/dd/yyyy.

No warranty on this little exercise. Check the workflow yourself before using it for real. I actually do not recommend using it, Nintex should come with a real solution.

But really... it is 2022 and we're talking 'global leaders' in software... That we still have to do this - even for the fun of it - is a bit of a shame, isn't it? 

[anissa_divincen]

Thank you so much, that workflow is exactly what I needed.  At least until they build this into NWC.  Amazed they haven't already. It works perfectly!

[EhlertS]

Hi,

the export key doen't work any more. Could you please send a new one, because i have to solve the same problem.

Thanks.

[WouterT]

Hi @EhlertS ,

Here is a new export key: QWuqEh5xFKWxmRhVSuFTNPGdEQNFmRQoGAy9ugfkrUhCcUZEz

[EhlertS]

It's a roundabout way - but it works - many thanks 🙂