2 Replies Latest reply: May 4, 2012 10:14 AM by Sudeep Mahapatra RSS

    Time format Hour:min (to show every 15 min in dimension)

    Sudeep Mahapatra

      Hi,

      I've a date/time field (field name as Timestamp) in my Data Model.

      Records of that field are like 2012-05-03 08:34:25, 2012-05-03 09:54:15, 2012-05-03 20:44:20 etc.

      Currently i'm using time(frac(Timestamp),'h:mm tt') which is giving the value like 8:34 AM, 9:54 AM, 8:44 PM

      I want to group them in every 30 min so that it shows 8:00 AM, 8:30 AM, 9:00 AM etc in my dimension.

      Please help.

       

      Thanks and Regards,

      Sudeep