Posted by Razvan Socol on 02/16/06 07:46

Hi, Frank

If you have a date and you want to obtain the corresponding date in the
previous year, you can use the DATEADD function, like this:
DATEADD(year, -1, @TheDate). For more informations, see:
http://msdn.microsoft.com/library/en-us/tsqlref/ts_fa-fz_2c1f.asp

Razvan

[Back to original message]