title: Why is this CAML Query is not filtering results from SharePoint Web Service call?
body: <p>I am trying to filter the list of results returned by the following web service call to a SharePoint list.  When I have</p>
  
  <pre><code>query.InnerText = "";
  </code></pre>
  
  <p>the results include every row in the SharePoint list - including rows having an IN SERVICE DATE less than today, greater than today, or no value at all.  I need the CAML query to filter, but adding the Where statement does not work.</p>
  
  <pre><code>service.Url = url;
  String pipeProjectSummaryListGuid = "{2D193799-F1FB-46B1-A313-56B8B12E1111}";
  
  XmlDocument xmlDoc = new System.Xml.XmlDocument();
  XmlElement query = xmlDoc.CreateElement("Query");
  XmlElement viewFields = xmlDoc.CreateElement("ViewFields");
  XmlElement queryOptions = xmlDoc.CreateElement("QueryOptions");
  String rowLimit = "9000";
  
  query.InnerText = "&lt;Where&gt;&lt;Gt&gt;&lt;FieldRef Name=\"In_x0020_Service_x0020_Date\" /&gt;&lt;Value Type=\"DateTime\"&gt;&lt;Today /&gt;&lt;/Value&gt;&lt;/Gt&gt;&lt;/Where&gt;";
  viewFields.InnerXml = "&lt;FieldRef Name=\"NEW_ID\" /&gt;&lt;FieldRef Name=\"In_x0020_Service_x0020_Date\" /&gt;&lt;FieldRef Name=\"ProjectPriority\" /&gt;";
  queryOptions.InnerXml = "&lt;ViewAttributes Scope=\"Recursive\" /&gt;&lt;IncludeMandatoryColumns&gt;FALSE&lt;/IncludeMandatoryColumns&gt;";
  
  try
  {
      results = service.GetListItems(pipeProjectSummaryListGuid, null, query, viewFields, rowLimit, queryOptions, null);
  }
  </code></pre>