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
