(CURRENT_DATE)-1 in OTBI Analysis Prompts Section
Summary(CURRENT_DATE)-1 in OTBI Analysis Prompts Section
Do you know how can this be used in Prompts. I have a Date Prompt and need to default the date as (CURRENT_DATE-1) because the report will be scheduled and can run adhoc when needed to input the dates by the user.
I tried this with SQL Expression in Prompts but didn't work.
CASE WHEN 1=0 THEN
"Cash Management - Bank Statements Real Time"."Time"."Report Date" ELSE timestampadd
FROM "Cash Management - Bank Statements Real Time"
When i tried this with Variable Expression and it's working correctly defaulting to CURRENT_DATE, but need (CURRENT_DATE)-1