Retrieve data between dates in laravel

Question

I am using an eloquent query to retrieve data from a table. The table columns look like this:

id started_at finished_at
1 06/02/2019 06/15/2019
2 06/05/2019 06/11/2019

What I want to do is, given a $date (ex: 06/08/2019 ) and get the data of the row, that the $date between started at and finished_at columns.

Vishal Thakkar · Accepted Answer · 2019-06-03 05:10:19Z

1

 DB::table('table_name')->whereBetween('started_at', [$date1, $date2])
  ->orWhereBetween('finished_at', [$date1, $date2])->get();

answered Jun 3, 2019 at 5:10

Vishal Thakkar

614 bronze badges

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

Comments

Karan · Accepted Answer · 2019-06-03 05:19:17Z

0

$date = date('Y-m-d',strtotime($started_at));


$data = Model::where('started_at', '>', $date)->where('finished_at', '<', $date)->first();

answered Jun 3, 2019 at 5:19

Karan

1,1561 gold badge10 silver badges24 bronze badges

Aditya Thakur · Accepted Answer · 2019-06-03 05:25:28Z

0

Try this

$data = Model::where('started_at', '<', $date)->where('finished_at', '>', $date)->first();

answered Jun 3, 2019 at 5:07

Aditya Thakur

2,6202 gold badges12 silver badges21 bronze badges