I have the column on the left side in the old format and the column on the right side in the new format, as requested by Knime, but it is giving an error using the Date & time string node.
Inside the string manipulation node I’m using this function join(substr($eta_destino_realizado$,6,4),“-”,substr($eta_destino_realizado$,3,2),“-”,substr($eta_destino_realizado$,0,2)," ",substr($eta_destino_realizado$,11))
Hi @Gabriel2020 , the format mask you are showing in the dialog has a literal ‘Z’ on the end of it. There is no letter Z at the end of the date so you should remove that from the mask.
If you were intending to use Z to represent timezone offset, you’d include it without the single quotes, but again there is no timezone offset in your datetime strings either, so it shouldn’t be there.
You don’t need the String Manipulation node here. Just use String to Date&Time against the original dates and overtype the format mask with this:
dd/MM/yyyy HH:mm:ss
It’s a common misunderstanding but you can overtype the format mask drop down in the Date&Time conversion nodes which I think is all you need here, but please say if I’ve misunderstood the problem.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
