The Convert function may do the trick SELECT Title, CONVERT(CHAR(10), BDate, 101) AS formattedDate, ID FROM YOURTABLE GROUP BY CONVERT(CHAR(10), BDate, 101), Title, ID
David DiPietro Systems Developer / Engineer OSU College of Medicine & Public Health Voice (614) 292-5960 Fax (614) 292-0745 -----Original Message----- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 4:59 PM To: CF-Talk Subject: Group by on date/time field <cf_BrainFart> I have a query that needs to be output in groups based on a datetime value (SQL Server 7.0/2000). The trouble I'm having is with the time value. I need to group on the date alone. Do I need to store the values seperately, or can SQL parse it in the query as only the date portion so CF can use it in the <cfoutput group="">? </CF_BrainFart> Jeff Beer Director of Application Development Digital Stormfront, Inc http://www.digitalstormfront.com <http://www.digitalstormfront.com> ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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