How can you select date-1 (or date-3) in a DB2 SELECT

[colezpapa3]

I need to query on a date value (last activity date value). The value is will normally be date-1, and date-3 on a Monday. How can I do it in a DB2 select.
I tried the following but it does not work....

DATE_DT = Case dayofweek(current date) When 2 Then current date - 3 day else current date - 1 day End

 

[blom0344]

CASE WHEN dayofweek(current date)=2 
then current date - 3 days
else current date - 1 days
end

Ties Blom

 

[colezpapa3]

Thank you, I almost had it...

thanks again