Date Time Parsing

[Gavin_Attard]

Hi Folks

I have been using the string to Date&TIme node to resonable success.
However where the strings do not match the pre-made date formats that you can select, i can’t convert/parse

Is there another node i missed or method where i can specify the format, for example YYYYMMddHHmm ?

thanks

Gavin

[morpheus]

Hi @Gavin_Attard,
could you please provide some examples how your date/time strings looks. Without any example it is difficult to come up with a suggestion or solution.

BR

[Gavin_Attard]

string = 202006231945

format i’m looking for is YYYYMMddhhmm

[morpheus]

You can manipulate the string e.g. with simple java snippet and convert it afterwards.

[Gavin_Attard]

Ya i figured a solution like that, but that’s a tedious additional step.

Maybe one for the devs to provide an option in the string to datetime to enter custom date parse strings.
@ipazin - This something you can make visible?

[ipazin]

Hi there @Gavin_Attard,

you can already input custom formats in String to Date&Time node.

Make sure to check node description for more proper placeholders.

Br,
Ivan

[andrejz]

Hi,

As @ipazin suggested use “String to Date&Time” node and use yyyyMMddHHmm as the custom format

[Gavin_Attard]

I’ll be damned! Thanks @ipazin i hadn’t realised that i coudl jsut put in a custom format, i thought it was just a drop down…

Ya then just had to change to the localDate pattern format
For the uninitiated - available here.

Thanks all

[morpheus]

Hi @ipazin,

nice! I had overseen this possibility.
Learning never ends.

BR
Hermann