Why are you even updating it - if you're just setting it back to the same created date? Also, you can use oracles default "sysdate" right in your table definition so that you don't have to add a date at all - if you are really just tracking the added date and not the updated date.
----- Original Message ----- From: "daniel kessler" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Monday, December 20, 2004 7:19 AM Subject: Re: updating my date_added from a form fails > Thanks Charlie, that worked great. > I guess I assumed that since form value "<number>" works fine as a number, > date would do the same. Guess it works this way since date is more > complex. > > I appreciate the help. May your code go smoothly today. > >>try wrapping Form.date_added in a createODBCDateTime() function (or >>just a createODBCDate() if you don't need time). >> >> >>On Mon, 20 Dec 2004 09:03:27 -0500, Daniel Kessler <[EMAIL PROTECTED]> >>wrote: >>> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188253 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54