title: Retrieve accepted offers from last week in Taleo
body: <p>I have a Taleo Client Connect export which retrieves offers from Taleo Recruiting 17.4. I want to filter my results to only include offers that were accepted within the past seven days.</p>
  
  <p>My filter works if I manually specify a date in the XML data, but I can't figure out how to calculate last week's date at runtime.</p>
  
  <pre><code>&lt;quer:filtering xmlns:quer="http://www.taleo.com/ws/integration/query"&gt;
    &lt;quer:greaterThan&gt;
      &lt;quer:field path="AcceptedDate"/&gt;
      &lt;quer:date&gt;2019-02-22&lt;/quer:date&gt; &lt;!--Should equal [CURRENT_DATE]-[7_DAYS]--&gt;
    &lt;/quer:greaterThan&gt;
  &lt;/quer:filtering&gt;
  </code></pre>
  
  <p><strong>How can I export offers that were accepted within the past week using Taleo Connect Client?</strong></p>
  
  <hr>
  
  <p><em>Full export</em>:</p>
  
  <pre><code>&lt;quer:query productCode="RC1704" model="http://www.taleo.com/ws/tee800/2009/01" projectedClass="Offer" locale="en" mode="CSV" csvheader="true" largegraph="true" preventDuplicates="false" xmlns:quer="http://www.taleo.com/ws/integration/query"&gt;
    &lt;quer:subQueries/&gt;
    &lt;quer:projections&gt;
      &lt;quer:projection&gt;
        &lt;quer:field path="AcceptedDate"/&gt;
      &lt;/quer:projection&gt;
      &lt;quer:projection&gt;
        &lt;quer:field path="Application,Candidate,Number"/&gt;
      &lt;/quer:projection&gt;
      &lt;quer:projection&gt;
        &lt;quer:field path="Application,Requisition,ContestNumber"/&gt;
      &lt;/quer:projection&gt;
    &lt;/quer:projections&gt;
    &lt;quer:projectionFilterings/&gt;
    &lt;quer:filterings&gt;
      &lt;quer:filtering&gt;
        &lt;quer:greaterThan&gt;
          &lt;quer:field path="AcceptedDate"/&gt;
          &lt;quer:date&gt;2019-02-22&lt;/quer:date&gt; &lt;!--Should equal [CURRENT_DATE]-[7_DAYS]--&gt;
        &lt;/quer:greaterThan&gt;
      &lt;/quer:filtering&gt;
    &lt;/quer:filterings&gt;
    &lt;quer:sortings/&gt;
    &lt;quer:sortingFilterings/&gt;
    &lt;quer:groupings/&gt;
    &lt;quer:joinings/&gt;
  &lt;/quer:query&gt;
  </code></pre>