One way is to 1) set a variable equal to a date (vdate1) 2) set a variable equal to another date 100 years later (vdate2) 3) set var a variable equal to the difference (vDifference = .vDate2 - vDate1) 4) issue an update command (update table set DateColumn = (DateColumn + .vDifference)
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Frank LaVolpa Posted At: Friday, July 08, 2005 1:55 PM Posted To: RB7-L Conversation: [RBG7-L] - Add 100 to the year? Subject: [RBG7-L] - Add 100 to the year? Hello everyone! We discovered today that many (over 9000) of our year entries we receive from an imported 3rd-party file are wrong. That table undergoes a LOT of changes, so simply reimporting the corrected table isn't an option for us. For all the records, how can I do this: If YEAR in FIELD <= 2035 then YEAR = YEAR + 100 It's probably important to note that the FIELD has a normal date format: MM/DD/YYYY Thanks! --Frank
