CODEWITHSUNDEEP
sqlsql-serversql-server-2017
Lee Barry
Lee Barry

Reputation: 13

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.

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

Upvotes: 1

Views: 930

Answers (1)

huMpty duMpty
huMpty duMpty

Reputation: 14470

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

Upvotes: 2

Related Questions