Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

convert date to MM/YYYY

2885278Oct 1 2015 — edited Oct 2 2015

Helo guys

I have an issue how to cast Date type (DD/MM/YYYY) to format like this "MM/YYYY".

when User chooses Period for example 12/31/2014 from Dashboard Prompt then in Column Heading will be Dec/2015.

See the following picture:

It's dashboard prompt

10-1-2015 11-15-15 AM.png

and Report will display like following

10-1-2015 11-15-29 AM-2.png

Guys would you please to suggest me or giving an advises how to deal this issue. Thanks a million to share to suggestion and advises.I really appreciate it.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 30 2015

Added on Oct 1 2015

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

5 comments

305 views