Calculating the date from the difference in weeks

Question

Example today @date = 2010-02-22 14: 17: 19.393 Number @weeks = 2 The equation I'm looking for is (@date - @weeks = 2010-02-08 14: 17: 19.393)

Answer 1

select dateadd(week, @weeks*-1, @date)