Add 28 years?!

[Sam]

Hi all,
I have a date 1969 and I want to run an update
query to add 28 years to this but need some guidance. I
have looked at the dateadd function but I am not too sure
if this is what I need.
I would welcome any hints?
Thanks
Sam

 

[Douglas J. Steele]

DateAdd is probably what you want. DateAdd("yyyy", 28, [MyDateField]) (or,
more specifically

UPDATE MyTable
SET MyDateField = DateAdd("yyyy", 28, [MyDateField])

 

[Sam]

Many thanks

-----Original Message-----
DateAdd is probably what you want. DateAdd("yyyy", 28, [MyDateField]) (or,
more specifically

UPDATE MyTable
SET MyDateField = DateAdd("yyyy", 28, [MyDateField])

--
Doug Steele, Microsoft Access MVP

Hi all,
I have a date 1969 and I want to run an update
query to add 28 years to this but need some guidance. I
have looked at the dateadd function but I am not too sure
if this is what I need.
I would welcome any hints?
Thanks
Sam

.