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

    Show only distinct time values in list box



      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