I would like a report to have two optional dates (ex. ${param1} >= startDate and ${param2} <= startDate)
The problem with this query is that it doesn’t include the second date, so I have tried "dateadd(D, 1, ${param2}). This causes problems when the second parameter isn’t provided. To fix this, I have been trying to find a way to default the second parameter to today’s date, but haven’t found any success.
See attached file.
oops. in attached file, I’m editing createTs1. I should be editing create Ts2. Sorry for that confusion.