>- see footer for list info -< I want to group a table by date. The date column is a date/time column but I want to group on a per day basis. i.e. <CFQUERY NAME="GetRequests2" DATASOURCE="#request.maindsn#"> SELECT day(R.RequestDate) as rd, Count(R.RequestID) AS Total FROM Requests R WHERE R.RequestDate BETWEEN #attributes.fromdate# AND #attributes.todate# GROUP BY day(R.RequestDate) </CFQUERY> This works fine but when the date span is over a month then the 1st June is obvioulsy treated as 1 as is the first of any month I want to group by the date irrespective of the time. Hope you get it. Allan _______________________________________________
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 -<
