Hi, What is the best way to group by months for a query that contains full (day, month, year) dates?
The query looks something like: startDate , user 10-JUN-2000, Bill 30-JUN-2000, Steve 15-SEP-2000, Phil I would like the results to be displayed thus: June 2000 Bill Steve September 2000 Phil Since the month would not be in a query column by itself I could not use it as cfoutput's group column. Ideally I would like some simple mechanism like: <cfoutput query="qryExampleDates" group="Month(startDate)"> I'm currently using CF5. I am thinking of manipulating the query recordset (in CF) to add a new column that just contains the month part of the date. cheers David ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
