BI Publisher (MOSC)

MOSC Banner

In BIP reports date parameter, "Date from" and "Date to" are not picking the date functions mentione

edited Feb 20, 2019 12:38PM in BI Publisher (MOSC) 5 commentsAnswered

hi,

In have a BIP report date parameter, the user will be restricted to select only the date from the calendar of the last two years to till today. So I tried to restrict the date in the calendar by applying  {$SYSDATE()-730$} or  {$FIRST_DAY_OF_YEAR()-2$}  in the "Date From" option of the date parameter. But the function is not applying to the result. still, it shows all the dates. Please provide the proper guidance on this issue.

BI Publisher version : Oracle BI Publisher 11.1.1.7.1 standalone application

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center