Forum Stats

  • 3,815,595 Users
  • 2,259,055 Discussions
  • 7,893,182 Comments

Discussions

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

BijuJb
BijuJb Member Posts: 3
edited Sep 23, 2019 11:51AM in Social Groups

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