We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

(CURRENT_DATE)-1 in OTBI Analysis Prompts Section

Accepted answer
71
Views
5
Comments
edited Jan 18, 2019 7:37PM in Reporting and Analytics for ERP 5 comments

Summary

(CURRENT_DATE)-1 in OTBI Analysis Prompts Section

Content

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.

 

SELECT
CASE WHEN 1=0 THEN
"Cash Management - Bank Statements Real Time"."Time"."Report Date" ELSE timestampadd
(SQL_TSI_DAY,-1,CURRENT_DATE) END
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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!