OBIEE 11g - Query for Yesterday Date

Using in Analysis:

"Date" IN (TIMESTAMPADD(SQL_TSI_DAY,-1,CURRENT_DATE))

Using sql query in the Dashboard Prompt:
SELECT TIMESTAMPADD (SQL_TSI_DAY,-1,CURRENT_DATE) 

FROM "Time"