update dates

[Guest]

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:

<cfinput type="text"
name="StartDate"
required="yes"
message="Start Date is needed"
value="#VARIABLES.StartDate#"
validate="USDate"
size="5"
maxlength="10">

[Dan_Bracuk]

<cfdump var="#form#">
<cfabort>

gets you started on your action page.

[Guest]

Thanks Dan. You have always been a great help. I did as you said and I am getting an output of:
'10-12-08
Could my issues becoming from this apostrophe? If so how do I get rid of it?

[Dan_Bracuk]

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.

[Guest · Accepted solution]

Thanks. I have changed my update to cfquery.