<div>
<div class="content wysiwyg-content">
I have a list that has an &quot;EventDate&quot; column. &nbsp;I want to be able to show items that are between the next 30 - 60 days. &nbsp; I have the following query but not working correctly<br />
<br />

<pre><code id="code-10-28280700-1">&lt;View&gt;&lt;Query&gt;&lt;Where&gt;&lt;And&gt;&lt;Geq&gt;&lt;FieldRef Name=&quot;EventDate&quot;/&gt;&lt;Value Type=&quot;DateTime&quot;&gt;&lt;Today Offset=&quot;31&quot;/&gt;&lt;/Value&gt;&lt;/Geq&gt;&lt;Leq&gt;&lt;FieldRef Name=&quot;EventDate&quot;/&gt;&lt;Value Type=&quot;DateTime&quot;&gt;&lt;Today Offset=&quot;60&quot;/&gt;&lt;/Value&gt;&lt;/Leq&gt;&lt;/And&gt;&lt;/Where&gt;&lt;/Query&gt;&lt;/View&gt;</code></pre>
<br />
Having the &lt;And&gt; returns nothing and the &lt;Or&gt; includes everything less than 60 and less than 30.<br />
<br />
Any ideas?
</div>
</div>


I have a list that has an "EventDate" column.  I want to be able to show items that are between the next 30 - 60 days.   I have the following query but not working correctly

(CODE)

Having the <And> returns nothing and the <Or> includes everything less than 60 and less than 30.

Any ideas?

CAML query SharePoint 2007

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.