|
|
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
Navigation:
[Reply to this message]
|