<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> ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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