I am having some trouble with the string to date&time node. I have dates that are in a British format that I need to use dd/mm/yyyy. KNIME does not find a suitable format (see pic) and when I try to enter dd/mm/yyyy in the date format for it to work with it does not work.
What am I doing wrong? Is there any way to work with dates in this format?
I was not expecting a problem with this. I have another column with dates in a similar format except sometimes it is dd/mm/yyyy, and sometimes it is either d/m/yy, dd/m/yy, or dd/mm/yy. Not looking forward to working with that one since what I thought would be easy is not working for me.
I appreciate all the help, the people on the forum are awesome!
I do not think Date Extractor works for this use case. It never guesses the British format dd/mm/yyyy when the US format mm/dd/yyyy is possible.
It does however handle the single digit dates, e.g., 5/2/2019, albeit wrongly in this case as it assumes that means May 2nd instead of February 5th. Is there some way to force it to stay on the British format?