SQL SERVER 2005: Arithmetic with dates
===

I would to write a simple SELECT statement, in SQL SERVER 2005, which does the following computation with date arithmetic:

Starting from the present date (this means getdate()), determine the previous MONDAY, and then SUBTRACT 70 days from that MONDAY, showing in output the resulting date.

How could I achieve this?

My difficult is mainly to determine THE PREVIOUS MONDAY.

Of course, if getdate() is MONDAY, the previous MONDAY is getdate()

Thank you in advance for your kind help.

UltraCommit
