Node String to Date Execution Failed

Hi,

I'm currently trying to convert string to date, with the String to Date/Time node. The date/time that need to be converted looks like this:

2015-03-10T12:21:56+00:00
2015-03-19T16:40:40+00:00
2015-03-22T03:24:23+00:00
2015-03-25T16:13:58+00:00

So in the date format I use:

yyyy-MM-dd'T'HH:mm:ssZ

However, the node failed to parse it. What did I do wrong?

Hi agp,

the format does not generate/accept the last colon. If you remove it it works.

Best, Iris

 

 

Hi,

I have a problem. I have a Double type that i need to convert in year. I tryed to convert double into int and then i used Number to String. In the end, i used String to Date with format “yyyy” or “uuuu” but it doesn’t work.

Hi there @Benedetta,

if I got you right you would like to have just “yyyy” in your column. To my knowledge it is not possible for Local Date type column to have only year in it. Either have it as String column either add day and month using String Manipulation node and then convert it.

Br,
Ivan