Hi Tim, At the mo I am using Access but would like solution that would work on any DB.
I think I will create a custom function like: AddDateCol(theQuery, newColumnName, datePart) It may even appear on cflib.org :-) cheers David -----Original Message----- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Monday, 15 July 2002 10:26 AM To: CF-Talk Subject: RE: cfoutput and grouping What DB are you using? Tim -----Original Message----- From: Whiterod, David (PLNSA) [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 14, 2002 8:49 PM To: CF-Talk Subject: cfoutput and grouping 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 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
