Calculate Date from the Difference in Weeks

Question

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

Answer 1

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

Answer 2

@Ralph Thank you,using your answer i got the following results GETDATE())=2010-02-22 15:14:37.687 select dateadd(week, 2*-1, GETDATE())=2010-02-08 15:14:37.687