Would you be able to share a packaged workbook showing what you've tried so we can take a look and try to help?
2 of 2 people found this helpful
We can create parameter with the all option, because if we use the list of dates avail in db then parameter will not update dynamically.
Please refer here
Find my approach as reference below and stored in attached workbook version 9.3
When Event is still open Event Close Date=NULL I take date of today
Event Closed Date adj: ifnull([Event Closed Date],today())
Date range.twbx 18.4 KB