Gavin-Adams
Explorer

Converting a string to date variable in NWC workflow

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?

0 Kudos
Reply
19 Replies
Sven
Nintex Workflow Cloud Expert
Nintex Workflow Cloud Expert

Re: Converting a string to date variable in NWC workflow

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

 

2022-03-01 12_17_08-Nintex Product Roadmaps - Nintex Community.png

Reply
WouterT
Contributor

Re: Converting a string to date variable in NWC workflow

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.
0 Kudos
Reply
anissa_divincen
Scholar

Re: Converting a string to date variable in NWC workflow

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

 

 

0 Kudos
Reply
Sven
Nintex Workflow Cloud Expert
Nintex Workflow Cloud Expert

Re: Converting a string to date variable in NWC workflow

Hi everyone,

 

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

 

regards

 

Sven

0 Kudos
Reply
WouterT
Contributor

Re: Converting a string to date variable in NWC workflow

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? 

0 Kudos
Reply
anissa_divincen
Scholar

Re: Converting a string to date variable in NWC workflow

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!

0 Kudos
Reply
EhlertS
Novice

Re: Converting a string to date variable in NWC workflow

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.

0 Kudos
Reply
WouterT
Contributor

Re: Converting a string to date variable in NWC workflow

Hi @EhlertS ,

Here is a new export key: QWuqEh5xFKWxmRhVSuFTNPGdEQNFmRQoGAy9ugfkrUhCcUZEz

0 Kudos
Reply
EhlertS
Novice

Re: Converting a string to date variable in NWC workflow

It's a roundabout way - but it works - many thanks
0 Kudos
Reply