How to get BIP Scheduled Report To Update 'As of Date' When Run
I'm having issues with a BIP scheduled report not updating the 'As Of Date' prompt when it's scheduled to run/send to the user. I have the report scheduled to run every Tuesday and Friday in hopes that the date will update each time it's run so the user has the latest list of all active employees. I've tried removing the 'As Of Date' prompt to be blank, but then the report fails and does not send.
In the Data Model, the prompt is set to default to the SYSDATE
Any help would be greatly appreciated!
Content (please ensure you mask any confidential information):