11 Replies Latest reply: May 17, 2016 4:33 PM by Sunny Talwar RSS

    Show only distinct time values in list box

      Hi,

       

      I am having a date field named 'CalenderDate' which is in 'DD/MM/YYYY HH:MM:SSS' format. I Want to only show 'HH' part of it in list box. The data is similar to below

       

      01/01/2012 10:15:123

      01/01/2012 10:16:876

      01/01/2012 23:11:111

       

      so there are multiple records for one date each having different time stamp.

      To show only 'HH' part in list box, I am using formula as =Date(CalenderDate, 'HH); it is returning HH part, but it is duplicating.

      As you can see there are two records having time stamp 10:15 and 10:16; so it is showing 10 two times in list box.

      I want to display it only once. Does anyone knows how to achive this?

       

      Thanks in advance.

       

      -

      Raj Patil