I have a web page that lists events, it is split into 2 categories:

• This week (today is FRIDAY so this is until SUNDAY)
• Next week (this is from MONDAY through to SUNDAY)
• Upcoming (this is for all events after the above, i.e. NEXT SUNDAY?)

I want to use carbon to capture these dates but can't seem to get 'next week' working.

I am using query scopes for this.

So for this week:

  function scopeThisWeek($query)
  {
    $date = Carbon::parse('this sunday')->toDateString();
    return $query->where('start_date', '<', $date);
  }

So this gets the date for the nearest sunday (this sunday) and then pulls any events with a start date before this sunday.

Next week:

  function scopeNextWeek($query)
  {
    $sdate = Carbon::parse('this monday')->toDateString();
    $edate = Carbon::parse('next sunday')->toDateString();
    return $query->where('start_date', '>', $sdate, 'and')->where('start_date', '<', $edate);
  }

Next week starts on monday so i have used 'this monday' to get that date and the query will pull any events with a greater start_date.. however i only want it to pull dates for that week so i have used 'next sunday' and added a second where clause that only pulls events less than that date... why isn't it working?

Finally is upcoming, this should pull in ANY events AFTER any of the above, so this would be 'next monday' ?

  function scopeUpcoming($query)
  {
    $date = Carbon::parse('next monday')->toDateString();
    return $query->where('start_date', '>', $date);
  }

This creates the date for next monday and pulls in any events with a greater date, the behaviour of this doesn't seem right either.

Where have i gone wrong?

edit: I tested the code to see what dates it spills out and it looks like this and next are the same thing?

This sunday: 2015-02-22

This monday: 2015-02-23

Next sunday: 2015-02-22

Next monday: 2015-02-23