title: Convert time stamp to date in query select statment in google spreadsheet
body: <p>I am importing data from a form data collection sheet and I would like to change timestamp to just date to make it easier for me to filter.</p>
  
  <p>What I want to do is to be able to filter data based on the dates that I provide so for example I would like to filter data between 4/20/2013 and 5/1/2013. Currently my time stamp is in datetime format making it difficult to do so.</p>
  
  <p>is there a way where I can do <code>Query(A:D,"select date(A), B, C",1)</code> so my table only has date not datetime or</p>
  
  <p>if I set
  A1 = 4/20/2013,
  B1 = 5/1/2013,
  C1 = <code>Query(Sheet1!A:D,"select A, B, C, D where A &gt;= date'"""&amp;A1&amp;"""' and A &lt;= date'"""&amp;B1&amp;"""'",1)</code></p>
  
  <p>Please help me with getting to this point</p>
  
  <p>Thank you</p>
  
  <p>Khokhar</p>