Updating date-field in database with ASP

[Guest_imported]

I've got a database that users are supposed to edit online. One of the columns is formated as date/time. When I try to update it using:

<%
MyTempDate=&quot;07/25/2001&quot; (actually read from a passed string)
Conn.Execute(&quot;Update MyTable Set UserDateField=&quot; & MyTempDate)
%>

or

<%
Conn.Execute(&quot;Update MyTable Set UserDateField='&quot; & MyTempDate&quot;'&quot
%>

I get error messages. I assume that the problem is to format it somehow, but I don't know how. The MyTempDate is gathered from a query from the table, so it should be in its correct format.

Can anybody help me? I'm freaking out cause I've got a deadline comming up.

Thx

 

[shaddow]

If u are in sql u must palce the date between quotes (ie '07/25/2001') or if u are using acess place # instead quotes (ie #07/25/2001#)
Also u need an where condition to make just one update not manny
try this

MyTempDate="07/25/2001"
Conn.Execute("Update MyTable Set UserDateField='" & MyTempDate & "' where UserDateField='"&oldvalue&"'")

________
George, M

 

[jcj88]

If you are using Oracle, consider using the TO_DATE SQL function to convert your string to a date.

I assume other databases would have a similar function but I could be wrong.