Help needed - string to date time conversion

Hello I am having difficulty with this String to date&time node.

I encountered the below error. Is anyone able to help? Thank you so much.

ERROR String to Date&Time 3:12 Could not parse date in cell [Row1_Row0, column “DATE”, row 1]: Text ‘01-7-2020’ could not be parsed at index 3.
RowID | … | Month Number | DATE | Counter

Row1_Row0 | … | 7 | 01-7-2020 | 1
^^^^^^^^^^
Could not parse date in cell [Row1_Row0, column “DATE”, row 1]: Text ‘01-7-2020’ could not be parsed at index 3.

Can you share the workflow? Its hard to help with just the error message.

TASK ASSESSMENT.knwf (618.6 KB)

Sorry attached is the KNIME workflow!

You’ve got the data in a local folder. Please post it or include it in a “data” folder in the workflow.

2 Likes

Try this. String to date won’t handle month names.
APPLE TASK ASSESSMENT.knwf (1.5 MB)
Sorry, in fact month names can be handled like this in your original workflow::



Desxription

3 Likes

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