Hi Claude, If QoQ, try using the CAST function.
http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=00001271.htm I haven't tested the following, just guessing what it might be. If it doesn't work, play around with it and/or google for ideas from what others have done. <CFQUERY NAME="mycalendar1" dbtype="query"> SELECT starttime, CAST(starttime AS DATE) AS startdate, [from] as sentfrom, endtime, subject, duration, location, message, organizer, htmlmessage, requiredattendees FROM mycalendar GROUP BY startdate, starttime, endtime, subject, sentfrom, duration, location, message, organizer, htmlmessage, requiredattendees ORDER BY starttime </cfquery> Thanks, Karen Johnstone --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
