Frank, UPDATE tablename SET columnname = (ADDYR(columnname, 100)) WHERE columnname <= 2035
Bill Frank LaVolpa 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 > > >
