Default dates as start and end of financial year

User_7Q1KS

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?

Mallikarjuna Kuppauru-Oracle

Hi,

Setting the default value at parameter level is one option but its an static value. use sql statement to get the value in dynamic manner.

Regards,

Arjun