What I mean is, if you select a date in your form, and cfdump (or cfoutput) the date before inserting to the DB. Just to make sure the form is doing the date correctly.
> -----Original Message----- > From: Robert Makowski [mailto:[EMAIL PROTECTED] > Sent: Friday, November 03, 2006 1:50 PM > To: CF-Newbie > Subject: RE: datefield problem > > I'm using an access database, and when I look at the actual > data in the > db, the value is 12:07:54 AM. So I'm very confused. > > -----Original Message----- > From: Munson, Jacob [mailto:[EMAIL PROTECTED] > Sent: Friday, November 03, 2006 3:29 PM > To: CF-Newbie > Subject: RE: datefield problem > > What date do you get if you cfdump the field contents? > > > -----Original Message----- > > From: Robert Makowski [mailto:[EMAIL PROTECTED] > > Sent: Friday, November 03, 2006 12:13 PM > > To: CF-Newbie > > Subject: datefield problem > > > > I'm using a flash form to enter some data, everything works > > fine, but the type=datefield is messed up. the time that is > > saved into the DB is same no matter what date that you click > > on the calander. Its some time in 1899 not a typo, and the > > time is all wrong as well. Could someone help with this problem. > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2200 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
