Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Need help
Summary
Need help with the Date prompt in OTBI reportContent
I have set up a date presentation variable for a OTBI report as a prompt (P_TO). Now I want to use the same in the SQL expression used in the filter set for one of field in the report (some thing like this) so that the report pulls all data between prompt date and prompt date -6. Can somebody help me with the expression.
"Element Entry"."Element Entry Creation Date" BETWEEN timestampadd(SQL_TSI_DAY,-6,DATE'@{P_TO}') AND @{P_TO}{date '2019-11-28'}
0