Hello,
My reports use two calendar objects as a date filter for all data:
- 1st object is the Start Date:
Min Value
=Min([Date Created])
Max Value
=$(vEndDate)
- 2nd object is the End Date:
Min Value
=$(vStartDate)
Max Value
=Max([Date Created])
Where [Date Created] is the date field from the data.
All the report charts and objects have a variable to select date based on the vStartDate and vEndDate selections.
This all works fine but the only "issue" is that the End Date is static and has to be manually set to "today" whenever a user opens up the report.
Is it possible to amend the object to change the default selection in the End Date Calendar Object to current system date? Note the report file is being reloaded every hour.
Any help is appreciated!
Best Regards
Marek
