I agree, you need to become familiar with the DateFormat function. Keep
in mind, no matter if you assign an time value or not, Access will store
both date and time in a datetime field.  

-----Original Message-----
From: Vohra, Sandeep Singh [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 26, 2007 9:39 AM
To: CF-Newbie
Subject: RE: Access

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
***********************************************************************
This email may contain confidential material. 
If you were not an intended recipient,
please notify the sender and delete all copies. 
We may monitor email to and from our network. 

***********************************************************************





~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:2469
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