Changing Dates' Years

[Anna]

Hi,

I want to update some DOBs that have been entered
incorrectly (i.e. it says they are born in 2019 when it
should be 1919). Is there a simple way I can knock 100
years off these dates?

Thanks,
Anna

 

[Douglas J. Steele]

Use the DateAdd function.

DateAdd("yyyy", -100, [MyDate])