Counting dates
I have data like this:
18/3/06 23:22
21/3/06 17:45
24/3/06 12:25
24/3/06 14:30
28/3/06 15:36
28/3/06 22:38
and I would like to be able to count how many enteries were made on a
date. (ie 18/3/06 = 1, 21/3/06 = 1, 24/3/06 2 etc) So far I have drawn
a blank as I keep getting stimied by the time in the date:time stamp.
My count is always = 1??
Ideally a look up table would be cool but I have no idea how to start
that!! ie just returning a date and count as a list.
Can anybody help?
Juan_Quar
|