How to change a string into a date format?

[millainthesky]

Hello everyone,
I need some help.
I have a string of type 20210325 that I need to transform into a date of type 2021-03-25 or better yet 25-03-2021. I have tried using the String to Date&Time node but it fails to perform this operation and therefore gives me an error output.
Could you please help me?
Thank you,
Camilla

[qqilihq]

@millainthesky

20210325

Hi Camilla,

you could use the Palladian Date Extractor for this, which would automatically determine the proper date format for you and then convert it back to a string in the desired format using Date&Time to String node using the format specifier yyyy-MM-dd.

Hope this helps!

– Philipp

Here’s a link to an example workflow on my NodePit Space:

Date_Parsing_31749 — NodePit

[millainthesky]

Thanks for your help!
I installed the Palladian extension and managed to solve the problem… thanks again!!!