I believe the String to Date&Time node has the logic backwards, for 12PM is returning 00 and for 12AM is returning 12. In the below screenshot 12:25 PM should be converted to 12:25 and 12:03 AM should be converted to 00:03 Sample data: 9/10/2020 12:25:00 PM 9/11/2020 12:03:00 AM [image] [image]

aah that makes sense. I ended up using this M/d/yyyy h:mm:ss a and it worked. Thanks a lot @elsamuel [image]

12 PM/AM String to DateTime Node logic is backwards

Alejandroc September 22, 2021, 5:14pm 6

I’m having a hard time converting those dates and saw this post