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 ?
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.
string = 202006231945
format i’m looking for is YYYYMMddhhmm
You can manipulate the string e.g. with simple java snippet and convert it afterwards.
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?
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.
As @ipazin suggested use “String to Date&Time” node and use yyyyMMddHHmm as the custom format
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.
nice! I had overseen this possibility.
Learning never ends.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.