sql - Hardcoded date required instead of automated date minus 1

Question

case when "DocDate"<=CAST(ADD_DAYS(CURRENT_DATE,-1) as date) then sum("TransValue") else 0

I need a hardcoded date instead of (CURRENT_DATE) so that my user can able to fetch the report on all days with actual result for that particular date.

Thanks Kumar

question from:https://stackoverflow.com/questions/65884721/hardcoded-date-required-instead-of-automated-date-minus-1

Answer 1

Waitting for answers