It has been a while since I have messed with the dataset options in the report designer. In the past I was able to set the dataset options to run reports on the current date and leave it like that within the report template.
The advantage to that is that anyone could run the report and it would generate results for that day.
However, I can't seem to remember the correct syntax. It was something like
Date = CURRENTDATE()
But that does not work and it will not verify.
Can someone please show me the correct way of doing this?