update just year

[rob b]

Is it possible to change just the year in a table of dates.
The year in the date field varies and I want to change them all to say 2002 without changing the day and month.
Ive tried picking certain years and then using dateadd to get the year I want but there has to be a quicker way doesn't there?
Any help would be appreciated.

 

[Alexandre]

UPDATE MyTable
SET MyTable.MyDateField= DateSerial(2002,Month([MyDateField]),Day([MyDateField]));
Alex

 

[rob b]

Alex
Thanks for your help it worked great.
Rob b