How do I find last weeks dates Monday to Friday using SQL Server?

Question

I'd like to find last weeks dates

SELECT *
FROM Table
Where [Date] Between '04-Jan-2016' AND '15-Jan-2016'

Every time I run my SQL Query it needs to display last week.

Answer 1

---To get the first day of the previous week in SQL Server, use the following code:

SELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),0)

--To get the last day of the previous week:

SELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),4)

Answer 2

SELECT *
FROM Table
Where [Date] Between DATEADD(wk,DATEDIFF(wk,7,GETDATE()),0) 
AND DATEADD(wk,DATEDIFF(wk,7,GETDATE()),4)