title: Google Sheets - Importrange Based on Date
body: <p>I have one spreadsheet that constantly gathers timesheets:</p>
  
  <pre><code>A        B            C
  Id |    Date    |   Time
  02   2018-05-26      60
  10   2018-05-25      40
  03   2018-05-23      30
  12   2018-05-20      95
  02   2018-05-18      15
  ...
  </code></pre>
  
  <p>On another spreadsheet, I have a date.</p>
  
  <pre><code>         A
  1    2018-05-28
  </code></pre>
  
  <p>I need to import all of the timesheets that were in that week (so the 7 days before that day.)</p>
  
  <pre><code>Dates &gt;= 2018-05-21
  </code></pre>
  
  <p>Therefore, I need:</p>
  
  <pre><code>A        B            C
  Id |    Date    |   Time
  02   2018-05-26      60
  10   2018-05-25      40
  03   2018-05-23      30
  </code></pre>
  
  <p>I have been trying to use:</p>
  
  <pre><code>=query(importrange("url", "A2:C"), "SELECT * WHERE Col3 &gt;= A1")
  </code></pre>
  
  <p>Yet, this gives a <code>#VALUE</code> Error.</p>
  
  <p>Thanks!</p>