how to update year in date field

[chabychab]

I would like to update only a specific year of a date field

e.g year(exp_date) = year(2013)

[Rabbit]

Use the dateadd function to add however many years you need.