Hello,

Please try this query.

set datefirst 7

select dateadd(dw,-(datepart(dw,getdate())+1),getdate())

Thank you

Regards

Mohit