AnsweredAssumed Answered

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

Question asked by suite48 on Jul 30, 2009
Latest reply on Jul 31, 2009 by 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!

Outcomes