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
