Hi, I have another problem with the converting date. In another database, I am working with a data format for monthly reports. The company writes as MMM-yy (ex: Oct-19), but this format detects as a string in KNIME.
I want to have a separated column for the “month” and “year” only. Firstly I thought I just need to convert from string to date then use “Extract date & time field” node to extract month and year.
Then, I got an error when tried using “string to date” node. I used the format below.
error message:
ERROR String to Date&Time 2:4 Execute failed: Failed to parse date in row 'Row103: Text ‘Oct-18’ could not be parsed: Unable to obtain LocalDate from TemporalAccessor: {MonthOfYear=10, Year=2018},ISO of type java.time.format.Parsed
Is there any way to convert string MMM-yy into a separated column of month and year?
Thank you