Not a Question: Dynamic Date Parameters in BI Report

Content

This is not a question and I have shared the info, For most of the BI Reports we have the input parameter as "AsOfDate" alias Sysdate or current date. Sometimes we also have a date range "From Date" and "To Date" to fetch transactions between those dates. And these dates need to have a default value when we open the report/schedule the report.

In this article we will try and see what are all the options possible for defaulting date parameters for BI Report.

Expression	Description	Date Format String
{$SYSDATE()$}	Current Date / System Date	MM-dd-yyyy
{$SYSDATE()+1$}	Day next to System date