title: Insert dates into Microsoft Access database
body: <p>How can I write the right syntax to insert a date into my database?</p>
  
  <p>This the SQL command that I already tried:</p>
  
  <pre><code>"insert into table1 (date) values (#"+DateTime.Parse(DateTime.Now.ToShortDateString())+"#)"
  </code></pre>
  
  <p>And also that:</p>
  
  <pre><code>"insert into table1 (date) values ('"+DateTime.Parse(DateTime.Now.ToShortDateString())+"')"
  </code></pre>