10 Replies Latest reply: May 4, 2017 5:03 PM by H�ctor Mu�oz 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