Solved How to update the century in a date field?

[rosef]

I am doing some data clean-up on a birthdate field. I have over 5000 records that need the 20XX changed to 19XX of the date field. Is there away that I can update just the 20 to 19? If so, how?

 

[theDBguy]

How about subtracting 100 years from it? Just a thought...

 

[Isaac]

Edit I was a moment too slow.

Yep - either what dbGuy said, or subtract 1 year from it.

 

[Minty]

You could use DateAdd("yyyy",-100,[YourDateField])


Edit - too slow....