2 Replies Latest reply: Oct 17, 2016 1:13 PM by Sunny Talwar RSS

    Format Timestamp by Hour

    Josh Akehurst

      I would like to show data by hour 12am - 12pm.  The expression below works, but I would like to display the PM time as 1pm, 2pm, 3pm, etc. instead of 13pm, 14pm, 15pm, etc.

       

      Any suggestions on how to update to adjust the timestamp for the PM hours? 

       

      Timestamp([Interaction Start Date Time UTC], 'h') & Timestamp([Interaction Start Date Time UTC],'TT')