Correcting Year - Need Replace Formula

[LaRetta]

Okay, now I know yesterday I said I LOVED formulas, because I had finally understood ONE ... today, I dislike them again

Somehow in my data migration, I have 67 Clients whose DOB is incorrectly starting with 20 and should be 19 (2089). I can isolate the records by finding >1/1/03 but, for the life of me, everything I try fails. I've tried Replace, Right, Case, Year(DOB) -1000 ... nothing is working. How do I change them to their correct 2-digit year beginning with 19? I will be using a Replace Calc through the set (stand-alone system) and it's a date field

[Vaughan]

Subtract 100 years from the date?

[LaRetta]

Oh Not much sleep! I meant 100. When I try Year(DOB) -100, it converts them all to 6/**/0006??

[Vaughan]

The expression needs to be

Date(Month(DOB), Day(DOB, Year(DOB) - 100)

You have to de-construct the date and re-construct it again.

[LaRetta]

I wouldn't have figured that out in a -- well --- 100 years!! Alright, formulas are *okay* I guess -- de-construct then re-construct, huh? Interesting. Thanks so much for helping me, Vaughan -- that worked perfectly!!