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

    DATEPARSE function returning PM times as AM




      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