title: Set Reporting services parameter value in subscription as current date
body: <p>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). </p>
  
  <p>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”.</p>
  
  <p>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. </p>
  
  <p>Thanks in advance!</p>
  
  <p>Helen</p>