SQL Statement to update the date

Question

I have a string 1993-08-02 00:00:00.0 and I would like to update the date field in a Access Table

This is what I have but it is not working.

UPDATE [Table] SET `Birthdate` = '1993-08-02 00:00:00.0' WHERE `ID` = 000

Solution

Dates are not strings, but either of the following will result in a date:

DATE [Table] SET `Birthdate` = CDate('1993-08-02 00:00:00.0') WHERE `ID` = 000

(see the documentation for CDate)

DATE [Table] SET `Birthdate` = #08/02/1993# WHERE `ID` = 000