title: Insert date using c# in MS Access
body: <p>Can anyone tell me what wrong i am doing while inserting date in into ms access?
  I am inserting date using below sql statement and date format is <code>d-M-yyyy</code></p>
  
  <pre class="lang-sql prettyprint-override"><code>insert into tbl_date(date_value) values(#8/7/2014#)
  </code></pre>
  
  <p>It's not showing me any error but store in access <code>7-Aug-2014</code> instead of <code>8-Jul-2014</code></p>
  
  <p>what is solution for this?</p>
  
  <p>Thanks in advance.</p>