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 below.

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.

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

Date 2: {$SYSDATE()$}

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

{$FIRST_DAY_OF_MONTH()$} – first day of the current month

{$LAST_DAY_OF_MONTH()$} – last day of the current month

{$FIRST_DAY_OF_YEAR)$} – first day of the current year

{$LAST_DAY_OF_YEAR)$} – last day of the current year