Using todays date in prompt for a scheuled report

Why use a variable when you can restricted the data at the query level?

Better to create an object called Today, as per this sticky thread in the Semantic Layer forum, then use it in the query conditions to build the logic required.