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!

Using a year parameter in a date condition

512966Mar 6 2008 — edited Mar 6 2008

I am collecting a year parameter from my user and want to use that year as part of a complete date condition.

So I collect the year 2003 from my user.

A condition is applied to the report in that the date must be after 01-APR-...and here is where i want to utilize the parameter @Year. So I can apply the same date condition depending on what year we are looking at.

I am sure this can be done but I am missing the syntax.

Thanks, mpaskevi

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 3 2008

Added on Mar 6 2008

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

6 comments

1,159 views