2 Replies Latest reply on Aug 17, 2016 8:54 AM by Tom W

    DATEPARSE function returning PM times as AM

    mike.roeslmeier

      Hello,

       

      I am using the DATEPARSE function to convert a field containing a time formatted as a string (ex. 09:41 PM). I am looking to convert the string into a Date/Time field. The function correctly parses any AM time value, however PM values are incorrectly parsed as AM.

       

      Underlying Data - DATEPARSE.JPG

       

      Any suggestions for how to correctly parse PM values would be greatly appreciated! Thanks!

       

      DATEPARSE Calc Field.jpg