Default Date in BIP Report Parameter of Oracle BI Cloud

To default a date in BIP Report parameter you can use sysdate function {$SYSDATE()$} as shown in the below screen shot

Some times we will also have a requirement to pass date range as 1 week or 1 months. In such cases we can create an expression using plus sign (+) and minus sign (-) to add or subtract days to default the date. For example if we want to default 1 week of date range in from and two date parameters, then we can use of expression.

From Date: {$SYSDATE()-7$}

To Date: {$SYSDATE()$}

Similarly, below are the additional functions provided by Oracle BIP.

1. {$FIRST_DAY_OF_MONTH()$} – first day of the current month
2. {$LAST_DAY_OF_MONTH()$} – last day of the current month
3. {$FIRST_DAY_OF_YEAR)$} – first day of the current year
4. {$LAST_DAY_OF_YEAR)$} – last day of the current year