Before you insert into the DB output the currentdate variable to see what it's holding. See if you can narrow down where the problem is.. CF or DB.. Also.. just one of my pet peeves.. Why are you using MS Access? Can you not use MySQL? or Postgres? They're both free and better than MSAccess..
On Tue, Mar 11, 2008 at 1:33 PM, Frank Velazquez <[EMAIL PROTECTED]> wrote: > 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:3412 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
