Value not writing to DB

[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??

 

[nicsin]

what db is it? For access:

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

 

[tdong]

ShipDate=NOW() "

that line is an error has to be "ShipDate =" & NOW() & "

 

[nicsin]

I assumed that the SHIPDATE is a date field. If it is a string then replace # with '