String to Date&Time

Hello there, I am struggling for hours and hours to transform two different columns from a string to a date and time format. Format of Column1: 10.05.2023 Format of Column2: 16:28:02.243. I am using the “String to Date&Time” node.
It surprises me how such a powerful tool will struggle with the simplest task. Please let me know if you have any suggestions. Thanks in advance!

Hi @Sustainability -

This one isn’t too bad once you know the syntax. Here’s an example using your sample data:

2023-05-22 12_23_51

MultiColumnStringtoDateTimeExample.knwf (16.1 KB)


This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.