sql week commencing date
snippet in sql

sql week commencing date

user5804

DATEADD(dd, -(DATEPART(dw, [Date])-1), [Date])