I have a CSV-File and all dates are imported as String in the format MM/dd/yyyy.
The String to Date Node is not able to convert the cell into suitable format (I tried to put the format manually, without success) and the Node failes. When I use the legacy Node, KNIME is able to convert the cell, but I’m not able use the Date Extraction Node.
but it is a String Column. It would be ok for me, if I could transform it to extract year, month, cw, day etc.
The String to Date Node delivers: ERROR String to Date&Time 0:9 Execute failed: Failed to parse date in row 'Row0: Text ‘4/28/2020’ could not be parsed at index 0
Hi @sven-abx , basically what you were using MM/dd/yyyy means 2 digits for month, 2 digits for day and 4 digits for year.
You can see from your data that it is not the case. For example, your 9/8/2018 shows that your date is formatted as M/d/yyyy. For it to be in the format of MM/dd/yyyy, this date would have to be as 09/08/2018.
So, the correct format for your dates is M/d/yyyy.
you are both right, I used m/d/yyyy now and it was working. Thank you very much!
All the time I was thinking, that some of the dates maybe need to be filtered, because of the string format.