Hi I’m having trouble parsing a string such as ‘23/10/19 7:12:00 PM’ using string to date time. I’ve used the format ‘dd/MM/yy hh:mm:ss A’ from the list but it says. ERROR String to Date&Time 3:2 Execute failed: Failed to parse date in row 'Row0: Text ‘01/01/19 10:08:00 AM’ could not be parsed at index 18 Any help would be much appreciated Thanks

Parsing date time using string to date

mlauber71 October 24, 2019, 8:34am 3

I changed the format to:

dd/MM/yy hh:mm:ss a

and now it seems to work

We had a similar discussion before and I came up with a little bit of a messy solution. Maybe as an inspiration if further problems occur:

3 Likes

12 PM/AM String to DateTime Node logic is backwards

Basic date time conversion