title: MS Access Date/Time format issue?
body: <p>This might be a possible duplicate, but I have a strange issue with MS Access DB.</p>
  
  <p>When I update a <strong>Date/Time</strong> value for my column <strong>req_date</strong>, I'm facing a problem.</p>
  
  <pre><code>10-03-2017
  </code></pre>
  
  <p>is getting updated as below</p>
  
  <pre><code>10-03-2017
  </code></pre>
  
  <p>where as </p>
  
  <pre><code>10-18-2017
  </code></pre>
  
  <p>is getting updated as below</p>
  
  <pre><code>18-10-2017
  </code></pre>
  
  <p>I'm using the following code in c# to Execute the query:</p>
  
  <pre><code>query = "update gb_jobs set req_delivery=myDate"
  myCMD = new OleDbCommand(query, con, trans);
  int tempCnt = myCMD.ExecuteNonQuery();
  </code></pre>
  
  <p>where as myDate is already converted to string from date time,</p>
  
  <p>As per the solution by Albert, I concatenated my <strong>myDate</strong> to <strong>#myDate#</strong> but it is throwing following error:   </p>
  
  <pre><code>query = "update gb_jobs set req_delivery=#myDate#"
  
  Error : Data type mismatch in criteria expression.
  </code></pre>