10 Replies Latest reply: May 4, 2017 5:03 PM by Hector Munoz RSS

    Group hours

    Ajinkya Bhonsle,

      Hi All,


      I have a "Date" field in the format  eg: "3/24/2017  1:05:00 AM". I used Time([Date], 'h tt') to get 1 AM, 2 AM , 3 AM etc.

      My problem is I get the data in the below format

      I would like to group these to show only


      01:00 AM

      02:00 AM

      03:00 AM


      Need help in achieving this