sql query modify the datepart week start date code example Example: sql week commencing date DATEADD(dd, -(DATEPART(dw, [Date])-1), [Date])