I have a dataset with some date columns in string format like Apr 11, 2021 . I am unable to convert those using the string to date&time node in KNIME. Anyone can please help.
Note that in the date columns I have some missing cells, wherever there is missing the final output should be missing as well.
I was trying with MMM DD, YYYY and getting the error. Now, as you suggested I tried with MMM dd, yyyy and its working for the cells where the string is Apr 11, 2021. However its not working where the string is in Apr 9, 2021. I have mentioned a sample data below -
Apr 9, 2021
Aug 7, 2021
Oct 2, 2021
Apr 30, 2021
Apr 15, 2021
May 25, 2021
? (missing)
? (missing)
? (missing)
In your original post you said that you had strings with 2 digit dates, so that’s the format I suggested.
Now you’re saying you also have single digit dates, I would try switching the format to MMM d, yyyy.