title: Eloquent multiple where from date fields <= >=
body: <p>I want to select Items from mySql table.<br>
  I use Laravel 5.2 &amp; Eloquent</p>
  
  <p>My table structure:<br>
  id | item_id | name | date_start | date_end</p>
  
  <ul>
  <li>id = primary, auto</li>
  <li>item_id = int</li>
  <li>name = text</li>
  <li>date_start &amp; date_end is 'Date' Type and have following format '2016-09-14'</li>
  </ul>
  
  <p><em>my query:</em></p>
  
  <pre><code>$dateFormated = date('Y-m-d',$tempDate);
  $items = ItemList::where('item_id', $id)
    -&gt;where('date_start', '&gt;=', $dateFormated)
    -&gt;where('date_end', '&lt;=', $dateFormated)
    -&gt;get()
  </code></pre>
  
  <p>If I <strong>remove one</strong> of my where <strong>clauses I get correct results</strong> for all Items with the right date_start/date_end value.</p>
  
  <p><strong>what am I doing wrong, what can I do?</strong></p>