title: Google Sheets =MONTH works but MONTH in QUERY does not
body: <p>Google Sheets: I checked my column of dates is in <code>DATE</code> format not <code>Automatic</code>.</p>
  
  <p>When I use <code>MONTH</code> in a cell I get the correct month back from that column.</p>
  
  <p>When I do a <code>QUERY</code> such as <code>=query('Main'!A1:M20,"select MONTH(M)",1)</code> I get <code>#VALUE!</code> with the comment: </p>
  
  <blockquote>
    <p>Unable to parse the Function <code>QUERY</code> for parameter 2: Can't perform the function <code>MONTH</code> on a column that is not a <code>DATE</code> or a <code>DATETIME</code> column</p>
  </blockquote>
  
  <p>Why does <code>QUERY</code> not see the column as being in <code>DATE</code> format but <code>=MONTH</code> does?</p>