depending on your database, you should have various functions available to you to extract just the date part from your datetime field. like DATE(yourdatefield) in mysql, for example...
Travis Haley wrote: > But I need the date, should I run this in a second query? > > Travis Haley > > -----Original Message----- > From: James Holmes [mailto:[EMAIL PROTECTED] > Sent: Monday, October 01, 2007 6:45 PM > To: CF-Talk > Subject: Re: Adding Small sections of a query > > Remove the date from the query. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289885 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
