Field doesn't write

[catalystunderx]

sqlString = "UPDATE Orders " &_
"SET Fulfilled=" & orderStatus & ", " &_
"ShipDate=NOW() " &_
"WHERE OrderID=" & orderID.............

the statement goes through fine and the fulfilled field writes fine but the shipdate (set as date format) field doesn't write??

 

[RoyVidar]

I would have thought it should (either that, or give a data type mismatch error), you could perhaps try:

[tt]sqlString = "UPDATE Orders " & _
"SET Fulfilled=" & orderStatus & ", " & _
"ShipDate=#" & format(now(),"yyyy-mm-dd") & _
"# WHERE OrderID=" & orderID.............
[/tt]

i e concatinating the date value into the string, here using ansi date format which is supposed to work on all databases.

Roy-Vidar