title: Date Parameters in FetchXML
body: <p>I am using FetchXML in SSRS 2008 to create a report from CRM 2011. I want to have parameters in the report so you can show the records between From Date -  To Date. This is the Query I have so far.</p>
  
  <pre><code>&lt;fetch&gt;
        &lt;entity name="appointment"&gt;
          &lt;attribute name="scheduledstart" /&gt;
          &lt;link-entity name="systemuser" from="systemuserid" to="ownerid"&gt;
              &lt;attribute name="firstname" alias="ownerFirstName" /&gt;
              &lt;attribute name="lastname" alias="ownerLastName" /&gt;
          &lt;/link-entity&gt;
          &lt;link-entity name="contact" from="contactid" to="new_contactperson"&gt;
              &lt;attribute name="parentcustomerid" alias="parentaccount" /&gt;
              &lt;attribute name="new_businessunit" alias="businessunit" /&gt;
          &lt;/link-entity&gt;
          &lt;attribute name="new_contactperson" /&gt;
          &lt;attribute name="subject" /&gt;
          &lt;attribute name="new_coldernotes" /&gt;
      &lt;link-entity name="activityparty" from="activityid" to="activityid"&gt;
      &lt;attribute name="participationtypemask" alias="participationtypemask" /&gt;
          &lt;filter&gt;
          &lt;condition attribute="participationtypemask" operator="eq" value="9" /&gt;
          &lt;/filter&gt;
          &lt;link-entity name="systemuser" from="systemuserid" to="partyid"&gt;
              &lt;attribute name="fullname" /&gt;
          &lt;/link-entity&gt;
      &lt;/link-entity&gt;
      &lt;order attribute="scheduledstart" descending="true" /&gt;
        &lt;/entity&gt;
  &lt;/fetch&gt;
  </code></pre>
  
  <p>How would I make it so I can filter between the dates?</p>
  
  <p>Thanks!</p>