Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 82 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Prefix SET VARIABLE PARAM_EFFECTIVE_DATE not working

rrr
Rank 3 - Community Apprentice
We are running some of our OTBI reports with a variable for a user-prompted date (data for a specific date).
Currently, the report variable uses and displays the wrong date format
We set the Prefix as:
SET VARIABLE PARAM_EFFECTIVE_DATE = '@{AsOfDate}{@{system.currentTime}[YYYY-MM-DD]}';
The return message is: "No Results"
When typing the date format 24-06-30, the report runs but retrieves data up to 24-06-2030 instead of 30-06-2024.
Is there any way to set the variable format?
0
Answers
-
Hi @rrr,
Have you tried entering the century as well?
The format is set to YYYY-MM-DD so maybe try 2024-06-30?
0 -
2024-06-30 retrieves "No Results"
0 -