title: CAML Query filtering data within a date range
body: <p>I want to retrieve items within a daterange from an <code>SPList</code>. The start date will be today and end date will be the day after 30 days from today. Here is my CAML query.</p>
  
  <pre><code>query.Query = string.Concat(@
      "&lt;Where&gt;
          &lt;And&gt;
            &lt;Geq&gt;
              &lt;FieldRef Name='EventDate' /&gt;
              &lt;Value IncludeTimeValue='False' Type='DateTime'&gt;&lt;Today /&gt;&lt;/Value&gt;
            &lt;/Geq&gt;
            &lt;Leq&gt;
              &lt;FieldRef Name='EventDate' /&gt;
              &lt;Value IncludeTimeValue='False' Type='DateTime'&gt;&lt;Today offset='30'/&gt;&lt;/Value&gt;
            &lt;/Leq&gt;
         &lt;/And&gt;
       &lt;/Where&gt;
       &lt;OrderBy&gt;
         &lt;FieldRef Name='EventDate' Ascending='True' /&gt;
       &lt;/OrderBy&gt;");
  SPListItemCollection items = list.GetItems(query);
  </code></pre>
  
  <p>But this will return only the items having today's date. </p>