1 Reply Latest reply on Jul 14, 2015 1:25 PM by pooja.gandhi

    Convert string to time

    Luke Stoughton

      Hi all,

       

      This is slightly different to previous threads.. I have a string value for time in the format 02:39 AM or 02:39 PM - i.e 24hr clock denoted by AM or PM suffix only. I need to convert this to a Time format but am struggling slightly having tried DATEPARSE and Googling to no avail.

       

      Any help appreciated.

       

      Thanks,

       

      Luke