Laravel: Compare two dates against today with Eloquent

Question

So I have events table which has start date and end date.

What I want to do is a comparison between today and start date + end date so if today is between start and end, return that collection which will be displayed on page, if it isn't ignore that event.

Problem is that when I retrieve an event I cannot access it as it is return that it doesn't exist in the collection, but it does after view is returned.

Here's my controller:

public function show($id)
{
    $today = date("Y-m-d");
    $today_dt = new DateTime($today);
    $event = Event::with('businesses')
        ->get();
    $test = $event->startdate;
    $test2 = $event->enddate;
    //something like if $today is not less that start date and not higher than end date, return that collection?
    dd($test);
    return view('events.showEvent', compact('event'));
}

What column type are you using to store your dates?

Rwd
– Rwd

2017-07-04 15:40:57 +00:00
Commented Jul 4, 2017 at 15:40 — Rwd
– Rwd, Commented Jul 4, 2017 at 15:40

Shahzaib Sheikh · Accepted Answer · 2017-07-04 15:58:02Z

1

use where date function like this

$today = Carbon::now();
$event = Event::with('businesses')
           ->whereDate('startdate', '<', $today->format('Y-m-d'))
           ->whereDate('enddate', '>', $today->format('Y-m-d'))
           ->get();

answered Jul 4, 2017 at 15:58

Shahzaib Sheikh

6671 gold badge10 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

omitobi · Accepted Answer · 2017-07-04 15:56:56Z

0

If I understood your problem correctly, I think this should suffice:

$today = Carbon::today();
$event = Event::whereDate('startdate', '>', $today->format('Y-m-d'))
    ->whereDate('enddate', '<', $today->format('Y-m-d'))
    ->with('businesses')
    ->get();

I hope you did search the internet for this problem in the first place

edited Jul 4, 2017 at 15:56

answered Jul 4, 2017 at 15:20

omitobi

7,3543 gold badges39 silver badges55 bronze badges

4 Comments

Przemek Wojtas Over a year ago

unfortunately this brings me back 0 results :(

omitobi Over a year ago

@PrzemekWojtas You can debug by testing what returns when you do only, Event::where('startdate', '>', $today->format('Y-m-d')) ->where('enddate', '<', $today->format('Y-m-d'))->get(); Look into your database and see a record you think should be returned, you can replace the $today to be your preferred date like: $today = Carbon::parse('22-01-2017'); for test purpose

omitobi Over a year ago

@ShahzaibSheikh how do you mean? You mean putting $today->format('Y-m-d') in single quotes? Actually the format() method of Carbon resolves to string at least with little I have seen it do, or did I misunderstand you?

Shahzaib Sheikh Over a year ago

whereDate('start', '<', $today->format('Y-m-d')) ->whereDate('end', '>', $today->format('Y-m-d'))->get()use like this

ZeroOne · Accepted Answer · 2017-07-05 07:43:00Z

0

in Model

public function scopeOfToday($query){
    $today = \Carbon\Carbon::today()->format('Y-m-d');
    return $query->whereRaw("? BETWEEN startdate and enddate",$today);
}

in Controller

public function show($id)
{
    $event = Event::ofToday()->with('businesses')->get();

    $test = $event->startdate;
    $test2 = $event->enddate;
    //something like if $today is not less that start date and not higher than end date, return that collection?
    dd($test);
    return view('events.showEvent', compact('event'));
}

edited Jul 5, 2017 at 7:43

answered Jul 5, 2017 at 4:48

ZeroOne

9,1374 gold badges30 silver badges48 bronze badges

2 Comments

Przemek Wojtas Over a year ago

I get that it doesn't exist in current collection

ZeroOne Over a year ago

which one doesn't exist?

Collectives™ on Stack Overflow

Laravel: Compare two dates against today with Eloquent

3 Answers 3

Comments

4 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related