I suppose in comment on the reason for this post is to 'Challenge Yourself'.  Not only in those things we thought we knew, as software changes and evolves, maybe some idioms are no longer valid.  I've been using SQL Server since Sybase was sucked up into the MS stable and there are still more things to learn (Thankfully !).   I thought that I knew dates but Itzik Ben-Gan's articles on Datetime calculation were a cool breeze throught the dusty portions of my briefcase.   So I suppose the challange is being open and prepared to be challanged.   and for those wondering ....

Last Monday (inclusive)

SELECT DATEADD(day, DATEDIFF

(day, 0, -- Base Monday date

GETDATE()) /7*7, 0); -- Base Monday date.

Pure genius....

CodeOn