STRING TO DATE TRANSFORMATION

Hi
I need to transform this field from a string into a date format:
image

I used String to Date&Time node but I cannot convert it. I have tried all the options but it does not work
I think it has an unusual format…Can you help me?
Thanks
Giada

Hi @giad

these settings should work:

SSS stands for the milliseconds and Z for the zone offset which is +0000 in your case.

Best,
Simon

6 Likes

H @giad,

Also, if you need only date, you can extract only the required part by using either substr/regex/len functions in string manipulation node then convert to date, provided your column data format is same.

hope this helps you… :slightly_smiling_face:

Regards,
Pavan

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.