title: CAML query with date filter, working in U2U query builder but not working in C# code
body: <p>Here is a CAML query which works fine in query builder but does not work work when used in code.</p>
  
  <pre><code>lstEmpQuery.Query = string.Concat("&lt;Where&gt;&lt;And&gt;&lt;And&gt;&lt;IsNotNull&gt;" +
                                    "&lt;FieldRef Name='Domain_x0020_Name' /&gt;" +
                                    "&lt;/IsNotNull&gt;&lt;Leq&gt;" +
                                    "&lt;FieldRef Name='Start_x0020_Date' /&gt;&lt;Value Type='DateTime'&gt;[Today+0Day(s)]&lt;/Value&gt;" +
                                    "&lt;/Leq&gt;&lt;/And&gt;&lt;Eq&gt;&lt;FieldRef Name='Is_x0020_Leaver_x003f_' /&gt;&lt;Value Type='Boolean'&gt;0&lt;/Value&gt;" +
                                    "&lt;/Eq&gt;&lt;/And&gt;&lt;/Where&gt;");
  </code></pre>
  
  <p>The query works fine in code and in query builder when date filter is removed i.e without the below piece</p>
  
  <p>
  
  [Today+0Day(s)]
  </p>
  
  <p>How can i make the query work withe the date filter. I tried passing <code>DateTime.Now</code> instead of <code>[Today+0Day(s)]</code> but still it does not work.</p>
  
  <p>Kindly help in this issue. Thank You.</p>