Please use DATEFORMAT function. <cfset todayDate = Now()> <li>#DateFormat(todayDate, "mmm-dd-yyyy")# <li>#DateFormat(todayDate, "mmmm d, yyyy")# <li>#DateFormat(todayDate, "mm/dd/yyyy")# <li>#DateFormat(todayDate, "d-mmm-yyyy")# <li>#DateFormat(todayDate, "ddd, mmmm dd, yyyy")#
Check CF Documentation around this function - http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functi59.htm Thanks. -Sandy V -----Original Message----- From: John Eubanks [mailto:[EMAIL PROTECTED] Sent: Thursday, January 25, 2007 10:02 AM To: CF-Newbie Subject: Access I have an access db that outputting a time/date format. However, I really don't want the time part of it to show up. Below is my code, if anyone would be interested: <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> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:2460 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
