i'm trying to create a query that returns the number of times a day occurs in my datetime field.
If it was just names or somethng i'd just do a distinct query but because the dates are stored as eg 2010-11-23 12:01:22 i can't as it would just return everything.
So somehow i need to chop the date down to day and count how many times it occurs.
i was thinking that if i put it into a while look and just chop the string and then count the amount of times each day occurs i could then output the values for each unique day.
Iam not sure where to start on the while loop though i can do the chopping but i don't know how to count each and then store that number against a a when it changes and then output it as an array.
any help or pointers would be appreciated