I think you're looking for DateFormat() http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functi59.htm
Also, you should get in the habit of using cfqueryparam in your queries. http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b20.htm And, I'd use CreateODBCDate() when you create your dates if you're using Access. http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functi49.htm Some light reading for ya. :) > -----Original Message----- > From: John Eubanks [mailto:[EMAIL PROTECTED] > Sent: Friday, January 26, 2007 8:25 AM > To: CF-Newbie > Subject: Access Date Time > > I have the following code: > > <cfset today = now()> > <cfset today = CreateDateTime(year(today), month(today), day(today),"23", "59", > "59")> > <cfset yesterday = DateAdd("d", -30, today)> > <cfset yesterday = CreateDate(year(yesterday), month(yesterday), > day(yesterday))> > > <cfquery name="get" datasource="CIC06"> > SELECT * > FROM Files_2 > WHERE DateUploaded BETWEEN #Today# AND #Yesterday# > Order By DateUploaded DESC > </cfquery> > <cfoutput query="get"> > #DateUploaded#<br> > </cfoutput> > > Which works fine, except: I can get rid of the time formatting (see below). Any > suggestions to make this work? > > 2007-01-24 00:00:00.0 > 2007-01-19 00:00:00.0 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2468 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
