I have simple query. I want to run report to show what POs generated yesterday if I run it on current date. POdate format is 'yyyymmdd'
SELECT PO, PODATE, from POTABLE WHERE PODATE=CONVERT(nvarchar,GETDATE(), 112)-1
above query is running fine but If I run report on Monday it should show me from last Friday to Sunday means last 3 days.
I tried to run this query but it showing incorrect syntex error message =' close to equal sign. What I am missing ?
select PO, PODATE from POTABLE WHERE
CASE
WHEN DATENAME(WEEKDAY, PODATE)='Monday' THEN PODATE =CONVERT(nvarchar,GETDATE(), 112)-1
ELSE
WHEN DATENAME(WEEKDAY, PODATE)<>'Monday' THEN PODATE=CONVERT(nvarchar,GETDATE(), 112)-3
END