Finding the date last year based on the current week and weekday using SQL Server

Today is the 21st of May, 2009 and it is a Thursday today. Have you wondered what date was Thursday last year in the same week? Here's a very handy query by Hector which displays the last year's date based on the current weekday and current week

SELECT DATEADD(day, (DATEPART(week, GETDATE()) * 7

+ DATEPART(weekday, GETDATE()))

- (DATEPART(week, DATEADD(year, -1, GETDATE())) * 7

+  DATEPART(weekday, DATEADD(year, -1, GETDATE()))), DATEADD(year, -1, GETDATE())) as LastYearDate

RESULT

LastYearDate

2008-05-22 11:14:26.350