I'm trying to group my query results by day. The field I'm grabbing from has a date/time stamp in it so what I'm getting are results grouped by time. I tried to fix this with this code which obviously doesn't work. How can I group this by date and ignore the time stamp?
<cfquery name="contact_count_ttl" datasource="#heinz.dsn#"> SELECT logdate, DATEPART(dy, logdate) as doy, COUNT(*) as count_ttl FROM customer_log WHERE logdate BETWEEN #start# AND #end# GROUP BY doy ORDER BY logdate </cfquery> Thanks Chris Christianson ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists