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
