title: Google Sheets: query to convert column to date and compare to another date
body: <p>I need to compare a text column, which contains a string that represents a date in the format dd/mm/yyyy, to another date.</p>
  
  <p>The range is in another sheet. I cannot edit it to format the column to a date field:
  <a href="https://i.stack.imgur.com/ZsQLI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZsQLI.png" alt="enter image description here"></a></p>
  
  <p>I need something like this:</p>
  
  <pre><code>=query(importrange(...); "select A, B WHERE C &gt;= '2017-01-08'")
  </code></pre>
  
  <p>Of course this doesn't work because only Aldo row will be visible. Is there any way to convert, in the query function, the column C to a date or to a string with the pattern yyyy-mm-dd to compare it to the right hand side value of the comparison?</p>