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:2459
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15