[RBG7-L] - Re: Add 100 to the year?

[Albert Berry]

UPDATE TheYearTable +
  SET TheYearCol = (ADDYR(TheYearCol,100)) +
  WHERE (IYR(TheYearCol)) <= 2035

--- Frank LaVolpa <[EMAIL PROTECTED]> wrote:

> 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
> 
> 


Albert Berry 
Management Consultant
RR2 - 1252 Ponderosa Drive
Sparwood BC, V0B 2G2 
Canada
(250) 425-5806
(250) 425-7259
(708) 575-3952 (fax)
[EMAIL PROTECTED]