Bill:  Here's an update statement to fix your dates:

UPDATE tablename SET datecolumn =
 (datecolumn + ( '1/1/1980' - '1/1/0080' ))
 WHERE datecolumn < '1/1/0100'


First..I took table from Dos To Windows with a date
field. All dates show ex: 01/01 00082 or 12/31/0083
IS THERE A WAY TO ADD 1900 TO MAKE DATES READ 01/01/1982 AND 12/31/1983? ALL
DATE FIELDS SHOULD BE 19XX



Reply via email to