how to use between with laravel query builder

Question

I am trying to use BETWEEN with laravel query builder. How do I do it. I have tried this below

Eventcalender::where(['between', 'acceptance_date', $final, $time])->count();

I don't think you can use 'between' like this. Instead, use whereBetween. Check the Laravel doc here: laravel.com/docs/6.x/queries — Rob
– Rob, Commented Jan 7, 2020 at 8:40

Community · Accepted Answer · 2020-06-20 09:12:55Z

6

Check hist out: whereBetween()

The whereBetween method verifies that a column's value is between two values,

Eventcalender::whereBetween('acceptance_date', [$final, $time])->count();

DB::table('eventcalenders')->whereBetween('acceptance_date', [$final, $time])->count();

CommunityBot

11 silver badge

answered Jan 7, 2020 at 8:38

TsaiKoga

13.4k2 gold badges23 silver badges31 bronze badges

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

1 Answer 1