0 Replies Latest reply on Sep 19, 2019 5:33 AM by BijuJb

    How to display or return query with 4 digit date format in brio ?

    BijuJb

      Hello Team,

       

      I use Brio 8.3 Hyperion Intelligence Explorer. Currently all the date fields is displaying as DD-MM-YY format. I would like to have them pulled in DD-MM-YYYY ie year in 4 digit format.Can you advice how to do it?

      Appreciate your early response. I searched in oracle  community for this and could not get any help/reference on this. Hence thought of asking here..

      I tired to change the datatype to Long text, date, string etc, but not getting desired result. When I pulled with datatype as =string, It displayed as YYYY creating issues when exporting to spreadsheet . I would like to have to date format showing up as DD-MM-YYYY or MM-DD-YYYY or YYYY-DD-MM provided the its a recognizable date format with 4 digit year.

       

      Message was edited by: BijuJb