Help needed - string to date time conversion

[LIM754]

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.

[rfeigel]

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

[LIM754]

TASK ASSESSMENT.knwf (618.6 KB)

Sorry attached is the KNIME workflow!

[rfeigel]

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

[rfeigel]

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::