DECLARE @T TABLE(tDate date) INSERT INTO @T VALUES ('01-01-2001') UPDATE @T SET tDate =DATEADD(YEAR, DATEDIFF(YEAR,tDate,GETDATE()),tDate) SELECT * FROM @T
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)