9 Replies Latest reply on Jul 31, 2009 9:27 PM by suite48

    How can i calculate the number of unique dates within a found set of records?

    suite48

      Title

      How can i calculate the number of unique dates within a found set of records?

      Post

      What is the easiest way to calculate the number of unique dates within a found set of records?

       

      E.g. if the results of my original querie is:

      record 1 date: 11/1/2009

      record 2 field A: 11/2/2009

      record 8 field A: 11/1/2009

      record 10 field A: 11/3/2009

      (4 records found)

       

      then I also want to know the number of unique dates for the found set  (in this case 3, i.e. 11/1/2009 which was found twice only counts as 1)

       

      Thanks!