6 Replies Latest reply: Jul 9, 2014 2:11 PM by Asad Raza RSS

    Remove Am and pm from Time Interval

      I have created a field by using

      INTERVAL(TIMESTAMP(ReloadTime(),'hhh:mm:ss')- INTERVAL(TIMESTAMP(EvDate),'hhh:mm:ss'))  AS Trial,

      And I believe the data is correct However, I would like to remove the AM and PM Fields, , I have attached a ss . Thank You in advance .