That did it!! THANKS EVERYONE!! WOOT! --Frank
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis Sent: Friday, July 08, 2005 1:20 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Add 100 to the year? Whoops, my previous missile had a + where it should have been a comma. Frank, assuming your year is in a date field: set var LimitDate date = 1/1/2035 update tablename set yourdate = (addyr(yourdate,100)) where yourdate <= .LimitDate Year is a reserved word. Bernie Lis ----- Original Message ----- From: "Frank LaVolpa" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Friday, July 08, 2005 2:55 PM 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 > >
