In oracle BI report publisher, I need to set querter start and end date as from date and to date par

Question

Summary

In oracle BI report publisher, I need to set querter start and end date as from date and to date parameter.

Content

I am a newbie to Oracle Bi Publisher reports. I have FromDate and ToDate parameters. I need to set it Quarter Start and End Date.

Please help.

What I have tried:

I tried to calculate the querter start end date using functions below but failed.

[Date Parameters in OBIEE]

Thomas Dodds · Answer

Term it a Running Quarter ... and see if they bite!

Pgoel · Answer

@Thomas, the second option what I also I was thinking. Although this will not give actual quart date but its somewhat close to it.

Sherry George · Answer

If your data model is a SQL query and would like have the report output alone default to quarter start and end, you can do it in the SQL query (data model) itself. But the default values that  could be set and displayed in parameter section is limited to what is described in the blog you attached.