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

Reply via email to