Add 28 years?!

  • Thread starter Thread starter Sam
  • Start date Start date
S

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
 
DateAdd is probably what you want. DateAdd("yyyy", 28, [MyDateField]) (or,
more specifically

UPDATE MyTable
SET MyDateField = DateAdd("yyyy", 28, [MyDateField])
 
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



Sam said:
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
Click to expand...


.
Click to expand...
 
Back
Top