- see footer for list info -<
I confess I do not like working with dates..
I have a table where a date is entered using the Date(now) function automatically.
So we end up with a Date Time Object.
I need to run a query to find counts of all the numbers of new entries by date.
eg..
5 on Wednesday 6 on Tuesday etc.
Really simple stiff like:
<cfquery name="getdata" datasource="#dsn#"> SELECT Count(abc.Regdate) AS CountOfRegdate, ABC.Regdate FROM Companies GROUP BY Companies.Regdate </cfquery>
where Regdate is the date I am after. This only works if the record is identical to the second. What is the syntax to Group by and get the totals by day?
Any sugesstions appreciated.
Gordon
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo
-- CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -< - Forum provided by www.fusetalk.com -< - DHTML Menus provided by www.APYCOM.com -< - Lists hosted by www.Gradwell.com -< - CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
