title: Access validation rules Date/Time
body: <p>I need to set up a small database as an assignment after 3 hours of an access introduction and I'm failing completely. However I youtubed several hours but still no change in the outcome. Do I try to implment too many excel functions into access?</p>
  
  <p>My question / problem:</p>
  
  <p>I have three tables for a dvd rental business. Customers, Movies, Rentals. </p>
  
  <p>Start and end date of rented movie, both data type "<code>Date/Time</code>" Start Date should be today by <code>default; validation rule: =Date() End date</code> should be equal or after </p>
  
  <pre><code>start date; validation rule: =[Enddate]&gt;=[Startdate]
  </code></pre>
  
  <p>I'm gettint an error messasge:</p>
  
  <pre><code>invalid SQL syntax - cannot use multiple columns in a column-level CHECK constraint.
  </code></pre>
  
  <p>I'm setting it up in the table properties not in the field, so what am I doing wrong?</p>