I have data with 8 date columns that have been exported from an Oracle database badly. The date format is MM/dd/yyyy which is not a problem for the node, but where the month number or the day is only 1 character the node throws an error like this:
“Failed to parse date in row 'Row0#0: Text ‘4/24/2014’ could not be parsed at index 0”
Is there a way to handle this error?
I could go and split cells, fix numbers, and recreate the string but would prefer something simpler if at all possible.