Strange date field in a table

[wasim_sono]

I had a table having field 'Date' with 'Medium date' property.I don'
know how user entered something that now some records show date a
'12-dec-1899' but in table when i click the field the text converte
to '00:00:09' and when leave the field it again show '12-dec-1899'
When i run an update query to change the contents of '12-Dec-1899' i
results '(0) rows updated.
Any help is appreciated

 

[Wayne Morgan]

It appears that you have a Date and Time in the field, but because of the
format, only the date shows until you click into the field. The update
probably didn't work because you were looking for fields equal to
12-Dec-1899, but the field may actually be 12-Dec-1899 00:00:09.

Have you tried manually highlighting the entire contents of the field and
typing in a new value? If so, what happens? Have you tried making a copy of
the file (as a backup) and doing a Compact and Repair?