how to ghange year only on date field

[Barra44]

Hi
I have a table with a date field dd/mm/yy
I would like to change all the dates in this table but I only want to change the year to 2003
and keep the day and month the same

is there an easy way of doing this without sitting there a manually changing 1200 records

Thanks in advance

 

[Golom]

Something like

UPDATE tablename SET 

TheDate = DateAdd ( "yyyy", 2003 - Year(TheDate), TheDate )

 

[Barra44]

Excelent
Problem solved

Thannk you very much