Node String to Date Execution Failed

[ezc201903]

Hey Guys,

I am looking to turn a string into a date and time. I am aware of the String to Date Node.

Date Column Ex: 08/05/2015 12:01:00 AM
String to date Format I used: M/d/yyyy;HH:mm:ss

For some reason, the node keeps giving me the following error:

Execute Failed to parse date in row "Row ): Text “08/05/2015 12:01:00 AM” could not be parsed, unparsed text found at index 10. (or index 19)

Any idea why this is? Am I not using the correct format?

Thanks,
Emily

[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)