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.
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.