Hi, I am facing issues in converting the string to date. Please have a look whether there is any issue with the format, thanks.
Following error is being observed.
Hi @nikola_tesla , what locale are you using?
Unfortunately Java date time conversion as implemented by this node is case sensitive and it is likely it requires the month to be Jan rather than JAN.
You could try using a string manipulation first and use a capitalize function to convert that portion of the string. I can’t recall if that will work directly where the letters are surrounded by hyphens. Haven’t got KNIME in front of me at there moment!
Hopefully it will then work.
btw, while not a problem with your example, I’d generally also recommend using just the d format mask for the day rather than dd as it is more flexible and will work with both leading zero dates and non leading zero, eg 09-Jan and 9-Jan, whereas dd will fail if dates are not two digit.
6 Likes
Thanks man, it is working now.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.