title: My query for grouping by date isn't working correctly. I'm always getting the last AND next few days, but I only want the upcoming ones
body: <p>I'm trying to group my meetings by date so I can get the meetings from today and the next three workdays. But that's not working very well. I'm always getting the next days <strong>AND</strong> the <strong>last day</strong> but I don't want that.</p>
  
  <pre><code>$grouped_meetings = Meeting::whereBetween('date', [Carbon::yesterday()-&gt;toDate(), now()-&gt;addDays($days_to_add)])-&gt;orderBy('date')-&gt;get()-&gt;groupBy(function ($val){
              return Carbon::parse($val-&gt;date)-&gt;format('l');
  });
  </code></pre>
  
  <p>I thought it works like selecting the dates between yesterday and the day I specify after that in my code. But it's always returning the meetings from <strong>yesterday</strong> too.</p>
  
  <p>I tried changing the <code>Carbon::yesterday()-&gt;toDate()</code> to <code>Carbon::now()-&gt;toDate()</code> and even <code>now()</code> but then I <strong>miss</strong> the <strong>current</strong> day.</p>
  
  <p>I have absolutely no clue why this is working like that and I don't know how to solve this problem.</p>
  
  <p><strong>Edit:</strong> the value of date is always a value in the format of <strong>YYYY-MM-DD</strong>.</p>