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.