nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Restricting calender data based on Year Filter in Dashboard Prompt

User_JL3CW

Hi all,

In my db prompt i have year and date column (calendar) as filters.

How to restrict calendar data based on year selected.

For eg: If i select 2016 as year then my date column (calendar) should display for 2016 only.

How to restrict this?

Regards,

Ram.

Find more posts tagged with

Accepted answers

All comments

User_JL3CW

Hi,

I have asked to describe the formula because of

1. In dashboard prompt, my selection is in MM/DD/YYYY format, and if i use PV in my report column it is giving correct result i.e in MM/DD/YYYY format.

When i use same presentation variable in the filter of the report it is giving YYYY-MM-DD format.

How did this formula has given the correct result?

Regards,

Ram.

asim cholas

Dear Ram,

The value we pass from dashboard prompt will be considered as a text and we need to convert it to date in column formula, For that you need 'Date' Function and which supports only the above syntax. .. May be @Christian Berg Or @gerardnico will be able to explain it further.

Thanks