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.
OTBI - prefix for current date minus days
Summary
How can I define prompt for an OTBI report which is the current date minus variable of daysContent
Hi,
I'm trying to create a prompt of number, so if the user will insert for example '20', the report will be effective for the current_date-20.
I'm trying to insert a prefix like this: SET VARIABLE PARAM_EFFECTIVE_DATE = '@{system.currentTime} -@{DaysMin}[YYYY-MM-DD]';
(DaysMin the a prompt var).
Unfortunately it does not work.
Do you have any suggestion?
Version
R13 18c0