Current Date and Yesterday Date in Dashboard Prompt

1. Create a prompt on date column as per your requirement
2. Expand Options and in Choice List Values option drop-down, select SQL Results and paste below Query ( Based on your Subject Area)

       SELECT CURRENT_DATE  FROM "Project - PRM and Time Management"
       UNION
       SELECT  TIMESTAMPADD(SQL_TSI_DAY,-1,CURRENT_DATE)  FROM
       "Project - PRM and Time Management"     

Thanks,
Naveen