update dates

Question

I am trying to update an Access database table that includes
a date/time column labeled "StartDate". When I insert the date, it
is inserted properly. When I come back to update the date, the date
that is entered is different int the database from what I entered.
It is sometimes years off. I have tried to format the date in the
form but I still get the error. I even tried to hard enter it
without varriables and I still have the issue. I am using a simple
CFUPDATE as well on the processing page. Here is the form element:

Anonymous · Accepted Answer

Thanks. I have changed my update to cfquery.

Dan_Bracuk · Answer

So you see 10-12-08. Was that what was in your text box?

Your bigger issues are probably a result of using one of the most ambiguous date format available. I'm guessing your record gets updated to Dec 12, 2010.

Solutions.
1. Don't blindly accept the form string as a date. Use createdate to turn it into a real date object.
2. Use cfquery instead of cfupdate. My understanding is that cfupdate only works with form variables.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.