It could be a date formatting incompatibility. Are you doing a cfqueryparam? If not, you might be sending the date in incorrectly. Unfortunately, I know 0 about MS Access.
> -----Original Message----- > From: Robert Makowski [mailto:[EMAIL PROTECTED] > Sent: Friday, November 03, 2006 2:34 PM > To: CF-Newbie > Subject: RE: datefield problem > > When I dumped the form.datecontacted the date was correct: 11/3/2006. > > So if that is the case what is actually happening? > > -----Original Message----- > From: Munson, Jacob [mailto:[EMAIL PROTECTED] > Sent: Friday, November 03, 2006 4:21 PM > To: CF-Newbie > Subject: RE: datefield problem > > 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. "EMF <idahopower.com>" made the following annotations. ------------------------------------------------------------------------------ This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. ============================================================================== ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:2202 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
