Node String to Date Execution Failed

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?


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.