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.
DATEADD(day, -1 - (DATEPART(weekday, GETDATE()) + CAST(Processed_Date As date) - 2) % 7, GETDATE() ) 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
SELECT DATEADD(wk, DATEDIFF(wk, 6, Processed_Date), 6) as LastSunday