title: User Input Date Range (mm/dd/yyyy)
body: <p>I am working in SQL and am trying to make a WHERE statement that allows the user to enter 2 dates, and all the data in between (and including) those dates are populated.</p>
  
  <p>My code is currently 
  <code>WHERE table.date BETWEEN 'StartDate' AND 'EndDate';</code>
  But when I try to execute the query, I get an error that says "Conversion failed when converting date and/or time from character string." I also tried to take away the '' and I get another error that says "Invalid column name"</p>
  
  <p>How can I fix this so that I can allow the user to enter a date (mm/dd/yyyy)?</p>
  
  <p>Customer | Price | date | Items |</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>Here's my actual code:</p>
  
  <p><code>SELECT [Customer],[Price],[Date],[Items]
  FROM table
  WHERE table.date BETWEEN ‘StartDate’ AND ‘EndDate’;</code></p>