[RBG7-L] - Re: dos to windows

[David M. Blocker]

Clever, Karen!!   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: [EMAIL PROTECTED] To: RBG7-L Mailing List Sent: Friday, August 13, 2004 9:12 AM Subject: [RBG7-L] - Re: dos to windows 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