Skip to Main Content

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!

Default dates as start and end of financial year

User_7Q1KSSep 12 2022

Hello,
I have a BI publisher report which uses 2 date parameters i.e. Start and End Date. They must be defaulted to the start and end of financial year. i.estart date would be 01-jul-2022 and end date 30-jun-2023 for this year.

Is there any function I can use for this in the default box or can we write SQL case statements in default value box?

Comments