Node String to Date Execution Failed

[mlauber71]

You could try this format (not the small a at the end):

MM/dd/yyyy HH:mm:ss a

And you could have a look at this discussion where we had similar data formats. I think we ended up having to deal with the AM and PM addition.

Messy Date & Time String Reformatting

OK I did a combination of the format “MM/dd/yy HH:mm a” extract the hour if the hour is 12 or AM nothing is added if the hour is PM 12 hours are added a date time shift brings back the military/real hour I wonder why it would not work with the original format because Java should be able to do that. Please check the solution. We Europeans use to struggle with the AM/PM concept. [image] kn_example_messy_date_time.knwf (370.2 KB)