The following config for “String to Date&Time” is not working:
Error:
ERROR String to Date&Time 3:34 Execute failed: Failed to parse date in row ‘Row0’: Text ‘Mon 02-Jan-2017’ could not be parsed at index 0
A string, “Mon 02-Jan-2017”, should be parsed by “EEE dd-MMM-yyyy” but isn’t. Could there be a UTF-8 thing or something like that?
Also tried string manipulation to remove the "Mon " part. So columns were just “02-Jan-2017” but could not be parsed by “dd-MMM-yyyy”. So it’s not the day name part that’s flopping. And it’s not extra spaces as the ERROR message shows the text is ‘Mon 02-Jan-2017’
Using KNIME 4.6.1