Ok I see what you mean, thanks guys! I am using 2008 so I could use datetime, but for my needs (working with an update on dummy databases) I don't...

Jeff, that worked perfectly and much simpler than the way I was approaching it. I was able to run the update on the entire table using that formula. Thank you!...

Hmm still can't get this one to work...any other suggestions?

I hear you...it is not my database though. The software stores it this way and I have to update all date fields as a way of becoming accustomed to the...

Thanks for taking the time to help David! That ran the update but the years were not correct. I will try to play around with it though.

Thank you so much!

It is going to take me a little bit to translate what you wrote into english 😀 (I am VERY new to this), but I will try...