Can't parse String to Date&Time

Hello,

New user trying to fix an issue with the String to Time&Date node.

the Workflow i set up takes a Excel file 5. Results atelierV14 (2).xlsx (427.9 KB)

and i try to converte the Start Column to string to Date&Time but i always geht a Error (ERROR String to Date&Time 4:25 Execute failed: Failed to parse date in row 'Row0: Text ‘01.01.20 00:25:00’ could not be parsed at index 2
)

I appreciate any feedback.

You need to specify an appropriate date format, based on the format you want KNIME to parse.

Try something like dd.MM.yy HH:mm:ss

2 Likes

Hello @esteinhi,

Welcome to the world of KNIME.
I had a quick look on both the xls file you are reading and the error message. The error is in row 0. Depending on the way you read the xls file row 0 might be the header line. In that case the message would be correct.
Maybe you can check the input data for the String to Date node.

You could get rid of the first line in several ways:

  • Start reading the xls file from line 2
  • Filter row 1 after reading
2 Likes

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