Jump to content

Correcting Year - Need Replace Formula


This topic is 7832 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

confused.gif

Link to comment
Share on other sites

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. smile.gif Thanks so much for helping me, Vaughan -- that worked perfectly!!

Link to comment
Share on other sites

This topic is 7832 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.