How to use the prompt in the Filter condition

Question

Currently we donot have a prompt and report fetches the data for the sysdate, with the filter condition as CURRENT_DATE BETWEEN "- Enrollment Results"."Enrollment Coverage Start Date" AND "- Enrollment Results"."Enrollment Coverage Through Date"

Requirement is, to run the report based on a Date that will be prompted. So, Instead of the CURRENT_DATE, the Prompt date should be used.

How to achieve this.

Thanks

Priscila Terazawa - Support-Oracle · Answer

Hi DPM,

Please check if this helps:

How to Use Presentation Variable in a Dashboard Prompt Where Date Operator is "Is Between"? (Doc ID 2447159.1)

Let me know if you have any questions.

Priscila Terazawa