2 Replies Latest reply on Apr 12, 2018 6:53 PM by bskumar.obiee

    Global Date format in OBIEE 12c

    bskumar.obiee

      Hi All,

      I'm facing a weird issue with one of the date column on the dashboard prompt. I have repository variable which is being used to show a default selection.

      So, the problem is that format of the date column in the report is 'DD-MM-YYYY' but when I choose any date from the prompt, the format is selected like this 'MM/DD/YYYY'.

      Also, I have set the NLS_DATE_FORMAT = 'DD-MM-YYYY' on the connection pool as well.

       

      Gurus.. Is there anything that I'm missing here? Please let me know.

       

      Thanks,

      Sai Kumar