One of my friend asked me logic/Query to find date of last Monday.
Everyday of the week can be identified as a number i.e. Sunday is 1, Monday is 2 and so on…
Since he wanted to find out date on Monday, it is 2nd day of week. Below is the logic
Monday Of The Week = Given date – (Day number of given week – 2)
We are using 2 because we want to find Monday. So the SQL query would be..
declare @date datetime
set @date = getdate()-10 — I have take any date
select @date – (DatePart(dw, @date)-2) — This is the logic which I explained earlier
Note: This depends on what the datefirst variable is set to. This would work only if DateFirst is 7 which is the U.S.English default.