Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Restricting calender data based on Year Filter in Dashboard Prompt

Received Response
221
Views
12
Comments
2»

Answers

  • User_JL3CW
    User_JL3CW Rank 6 - Analytics & AI Lead

    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
    asim cholas Rank 6 - Analytics & AI Lead

    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

    Aj