Set Reporting services parameter value in subscription as current date

Question

In reporting services SQL server , when I created a subscription for a report with parameter as date time type, I don’t know how to set up value of the parameter as current date (wherever the subscription is running).

I tired Today(), Today, today, @ExecutionTime. But none of them worked for me. Only a specific date worked eg: “11/11/2010 00:00:00”.

I also tried to hide the parameter but the subscript still required to fill the parameter. For the "default value” textbox did not allow the value “Today()”, “Today”, etc.

Thanks in advance!

Helen

Answer 1

You need = to make it an expressions

= Today()

Answer 2

You can't put "=today()" in the text box prompt at runtime. You have to setup the parameter's default value as "=today()" in visual studio.