Prefix SET VARIABLE PARAM_EFFECTIVE_DATE not working

Question

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?

Mark Stoker · Answer

Have you set up the Presentation Variable similar to below?

If yes, could you please attach your xml for your report?

Thanks

Mark

rrr · Answer

https://community.oracle.com/customerconnect/discussion/comment/1176715#Comment_1176715

2024-06-30 retrieves  "No Results"

Mark Stoker · Answer

Hi @rrr,

Have you tried entering the century as well?

The format is set to YYYY-MM-DD so maybe try 2024-06-30?