In BIP reports date parameter, "Date from" and "Date to" are not picking the date functions mentione
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