title: What is the default date format for access input?
body: <p>I am not really experienced with <code>ms-access db</code>. I have the following sql-code that ask for input from the user: </p>
  
  <pre><code>SELECT c.the_date, E.[iD #] AS ID, E.[first name] AS fname
        FROM [date-table] AS c, employeetbl AS E
  WHERE c.the_date between [enter a beginning date] and [Enter an end date];
  </code></pre>
  
  <ul>
  <li>What format should the input date from the user be? (<code>mm-dd-yyyy</code> or <code>dd-mm-yyyy</code>) </li>
  <li>Is <code>mm-dd-yyyy</code> format for date type in ms access by default? </li>
  <li>Can I also determine the default format? or can I somehow change this
  using    either access vba or sql. <br><br></li>
  <li>I also want to keep looping until the user inputs the right date
  format. Is this possible in vba?</li>
  </ul>
  
  <p>Any help will be appreciated. </p>