Issue in weekly schedule Bi report with effective date parameter

Summary:

Issue in weekly schedule Bi report with effective date parameter

Content (required):

Hi Team,

Recently I was schedule a report which is weakly basis and it contain one of the parameter called as Effective date.

Actually when the schedule day come, I need a report with effective date as SYSDATE. But it will take SYSDATE date as the day that I was schedule

So, my requirement is when the day came for scheduling the report automatically the effective date should be pick as schedule date.

Ex:- Weekly basis Report

schedule start date -3/28/2022

Effective date parameter- {would be change daily and effective date would be the schedule start processing date see below pic}