Set your db column to datetime and use CreateODBCDateTime(Now()) to create a valid datetime object.
Mike Chytracek Managing Partner Ignite Solutions p. 312.239.0032 c. 815.302.3507 f. 866.839.7896 -----Original Message----- From: Frank Velazquez [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2008 1:34 PM To: CF-Newbie Subject: Issues with NOW() and MSaccess Hey guys what's up? I'm Having issues with the following statement: <cfset CurrentDate = Now()> I have this cfset getting the time to submit it in a hidden field in one of my forms When the data is inserted into the database I get the following: 4/6/1894 And when I output I get this: 1894-06-04 00:00:00.0 <--- The "00:00:00.0" doesnt show on my db Why is this? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3413 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
