title: Excel timestamp as parameter in MS Query results in Conversion Error
body: <p>If found this thread, but unfortunately it didn't help:</p>
  
  <p><a href="https://stackoverflow.com/questions/26130283/excel-date-parameter-in-sql-query/38784876?noredirect=1#comment64940365_38784876">Excel date parameter in SQL query</a></p>
  
  <p>I tried the solution in the thread above and I get the following results:</p>
  
  <p>Using the ODBC connection I have to use the below in order for it to accept the query:</p>
  
  <pre><code>HPD_Help_Desk.Submit_Date &gt; { ts '2016-08-01 00:00:00' }
  </code></pre>
  
  <p>I've replaced this to the below, cause there is no other way (that I've found) it takes the parameter </p>
  
  <pre><code>HPD_Help_Desk.Submit_Date &gt; ?
  </code></pre>
  
  <p>My Original Cell value is:</p>
  
  <pre><code>7/31/2016
  </code></pre>
  
  <p>With the formula I tried several formats</p>
  
  <pre><code>=LOWER(TEXT(C2,"YYYY-MM-DD"))
  =LOWER(TEXT(C2,"dd-mmmm-yyyy"))
  </code></pre>
  
  <p>when I try the solution above I get the error. I get the same error if I just point straight to the date value in Excel: </p>
  
  <pre><code>[AR System ODBC Driver]Conversion Error
  </code></pre>
  
  <p>if I try this formula</p>
  
  <pre><code>=LOWER(TEXT(C2,"yyyy-mm-dd HH:mm:ss"))
  </code></pre>
  
  <p>I get the exact timestamp string '2016-07-01 00:00:00' but then I get:</p>
  
  <pre><code>[AR System ODBC Driver]Unrecognised Data Format
  </code></pre>
  
  <p>Any ideas if it's a limitation, or I'm just doing something wrong?</p>