Updating a date/time field

[Lewe22]

I am trying to perfrom an update to approximately 1500 records within a table named "fes_addresses". (I have restricted it to one record for the example.)

See Access query SQL:

UPDATE FES_ADDRESSES 
SET FES_ADDRESSES.OWNER_TYPE = "O", 
    FES_ADDRESSES.UPDATED_DATE = #11/21/2007 9:10:00#
WHERE (((FES_ADDRESSES.OWNER_TYPE)="S") 
AND ((FES_ADDRESSES.ADDRESS_TYPE)="S") 
AND ((FES_ADDRESSES.OWNER_REF)="601150"));

The updated_date field is not updating at all, i believe due to the formatting of the date. Any ideas??

fes_addresses is an oracle table and the field updated_date has the data type Date/Time.

Do i need to be using some variation of the TO_DATE function?

[Lewe22]

I have resolved this query. It was a problem based around constraints and not the date format.