Calculate the previous sundays date from a Date column?

I have a table that contains a field t.Processed_Date. I need to return the Previous sunday of that date. Everything I’m trying is not working.

    -1 - (DATEPART(weekday, GETDATE()) + CAST(Processed_Date As date) - 2) % 7,
) As 'Last Sunday'

But this gives an error

Msg 206, Level 16, State 2, Line 3
Operand type clash: date is incompatible with int

Server is MS SQL Server 2017 standard

>Solution :

SELECT DATEADD(wk, DATEDIFF(wk, 6, Processed_Date), 6) as LastSunday

Leave a Reply