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!

How to extract MONTH and YEAR form date promt

user10800227Mar 4 2009 — edited May 5 2009

Hi,

I have a presentation variable, V_DATE, that is populated by a calendar column in my prompt.

In answers I want to take a YEAR column and compare it to the year of V_DATE. I have tried things such as a column filter on YEAR where YEAR = YEAR(@{V_DATE}).

I can't seem to get this to work. I get all sorts of different errors when I try to cast things or use different conversions.

Any ideas?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 2 2009

Added on Mar 4 2009

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

4 comments

1,933 views