title: How is the fetchXML Date Operator resolved by the system
body: <p>CRM 2013-OnPremise</p>
  
  <p>Hello,</p>
  
  <p>I have written a basic View for projects with a start date in the next seven days that is defined by this fetchXML:</p>
  
  <pre><code>&lt;fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" &gt;
    &lt;entity name="xxxx_project" &gt;
      &lt;attribute name="xxxx_startdate" /&gt;
      &lt;attribute name="xxxx_accountid" /&gt;
      &lt;attribute name="xxxx_produom" /&gt;
      &lt;order attribute="xxxx_name" descending="false" /&gt;
      &lt;filter type="and" &gt;
          &lt;filter type="and" &gt;
              &lt;condition attribute="statecode" operator="eq" value="0" /&gt;
              &lt;condition attribute="xxxx_projectstatus" operator="eq" value="331420009" /&gt;
              &lt;condition attribute="xxxx_materialsshipdate" operator="null" /&gt;
              &lt;condition attribute="xxxx_startdate" operator="next-x-days" value="7" /&gt;
          &lt;/filter&gt;
      &lt;/filter&gt;
      &lt;attribute name="xxxx_projectid" /&gt;
    &lt;/entity&gt;
  &lt;/fetch&gt;
  </code></pre>
  
  <p>Now I was expecting the fetchXML to have the system date injected into it or at least a place holder such as:</p>
  
  <pre><code>&lt;condition value='2012-03-08T15:10:00Z' /&gt;
  </code></pre>
  
  <p>Perhaps this value is added at runtime and is not part of the fetchTemplate? So Msoft does some runtime changes to something like this?</p>
  
  <pre><code>&lt;condition attribute="xxxx_startdate" operator="next-7-days" value="2014-04-23" /&gt;
  </code></pre>
  
  <p>This article says it is injected <a href="http://social.microsoft.com/Forums/en-US/c5083689-65fb-474f-a7bc-2eff393016fe/datetime-on-or-after-of-fetchxml-questions?forum=crmdevelopment" rel="nofollow">http://social.microsoft.com/Forums/en-US/c5083689-65fb-474f-a7bc-2eff393016fe/datetime-on-or-after-of-fetchxml-questions?forum=crmdevelopment</a></p>
  
  <p>But does not give me any idea of what that should look like.</p>
  
  <p>The reason I ask is that I want to use this basic fetchXML as a template but inject a date of my choosing.</p>
  
  <p>Any idea?</p>