Search content within the blog

Monday, May 25, 2009

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

No comments:

Post a Comment