title: Excel: Query SQL table with date parameter from cell
body: <p>I have an ODBC connection, which simply queries a SQL table:   </p>
  
  <pre><code> SELECT * FROM [TABLE] WHERE myDate = ?
  </code></pre>
  
  <p>If I run the query in MS Query, it prompts for a date and I can just enter <code>4/2/2015</code> and it returns <code>4/2/2015</code> data perfectly   </p>
  
  <p>I have the parameter set to read from cell (B1):</p>
  
  <pre><code>=WorkSheetName!$B$1
  </code></pre>
  
  <p>When I switch back to Excel and put <code>4/2/2015</code> in <code>B1</code> and then refresh - it gives me a conversion failed when converting date and/or time from character string error.</p>
  
  <p>I tried editing my query to <code>WHERE CONVERT(Varchar(10),myDate,101) = ?</code> but had no luck.  Not sure why I am getting this, seems like it should be so simple.  </p>