title: invalid datetime format: insert date/time into Access from Java
body: <p>I want to insert a datetime value to Access, but I get this error:</p>
  
  <blockquote>
    <p>net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.4 data exception: invalid datetime format</p>
  </blockquote>
  
  <p>Here is the code : </p>
  
  <pre><code>private void txtsubmitActionPerformed(java.awt.event.ActionEvent evt) {                                          
      SimpleDateFormat A = new SimpleDateFormat("dd/MM/yyyy");
      Peminjaman P= new Peminjaman(setIDTrans(),txtid.getText(),A.format(txttglpinjam.getDate()),A.format(txttglkembali.getDate()),txtplat.getText(),txtnama.getText(),txtdriver.getText());
      c.InsertPeminjamanD(P);
  </code></pre>