If you can'rt change the query, I would do exactly what you are thinking, q of q with CreateDate(Year(startDate), Month(startDate), 1)
> -----Original Message----- > From: Whiterod, David (PLNSA) [mailto:[EMAIL PROTECTED]] > Sent: Monday, 15 July 2002 12:49 p.m. > 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 > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
