title: MS CRM 2011 Fetch XML Filter Expressions
body: <p>I have a fetch xml query and I would like to filter records with a date &amp; <strong>time</strong> field.</p>
  
  <p>I use the expression <strong>on or before</strong> but this seems to filter only date (<em>without time</em>).  </p>
  
  <pre><code>FetchXml= ...
  '&lt;filter type="and"&gt;'+
  '&lt;filter type="or"&gt;'+
      '&lt;condition attribute="scheduledend" value="'+ currentdate +'" operator="on-or-before"/&gt;'+
      '&lt;condition attribute="scheduledend" operator="null"/&gt;'+
  '&lt;/filter&gt;'+
  '&lt;/filter&gt;'+
  </code></pre>