title: SQL Reporting Services 2005 - How to get current date as a ReportParameter
body: <p>I have some working reports that must be deployed on SSRS. 
  One more customization that I want to be added is to automatically select the FromDate as today - 1 month, and ToDate as today.</p>
  
  <p>Specifically, I want to replace the fragment bellow with a piece that accomplish the requirements above:</p>
  
  <pre><code> &lt;ReportParameter Name="FromDate"&gt;
    &lt;DataType&gt;String&lt;/DataType&gt;
    &lt;DefaultValue&gt;
      &lt;Values&gt;
        &lt;Value&gt;[Date].&amp;amp;[2008-09-26T00:00:00]&lt;/Value&gt;
      &lt;/Values&gt;
    &lt;/DefaultValue&gt;
    &lt;Prompt&gt;From Date&lt;/Prompt&gt;
    &lt;ValidValues&gt;
      &lt;DataSetReference&gt;
        &lt;DataSetName&gt;FromDate2&lt;/DataSetName&gt;
        &lt;ValueField&gt;ParameterValue&lt;/ValueField&gt;
        &lt;LabelField&gt;ParameterCaption&lt;/LabelField&gt;
      &lt;/DataSetReference&gt;
    &lt;/ValidValues&gt;
  &lt;/ReportParameter&gt;
  &lt;ReportParameter Name="ToDate"&gt;
    &lt;DataType&gt;String&lt;/DataType&gt;
    &lt;Prompt&gt;To Date&lt;/Prompt&gt;
    &lt;ValidValues&gt;
      &lt;DataSetReference&gt;
        &lt;DataSetName&gt;ToDate&lt;/DataSetName&gt;
        &lt;ValueField&gt;ParameterValue&lt;/ValueField&gt;
        &lt;LabelField&gt;ParameterCaption&lt;/LabelField&gt;
      &lt;/DataSetReference&gt;
    &lt;/ValidValues&gt;
  &lt;/ReportParameter&gt;
  </code></pre>
  
  <p>Thanks in advance. </p>