whereBetween 2 months

I need to fetch data between 2 months, I have a date picker which the user chose months which goes to the controller as following $from = 01-2022, $to = 10-2022, how to get the data between these months.

the method that I used but not working

$query = Appointment::select('id',) ->whereBetween('created_at', [$from,$to]) ->get()

tykus

4 years ago

Best Answer

Level 104

$query = Appointment::select('id')
    ->whereBetween('created_at', [
        Carbon::createFromFormat('m-Y', $from)->startOfMonth(), //2022-10-01 00:00:00.0
        Carbon::createFromFormat('m-Y', $to)->endOfMonth() // 2022-10-31 23:59:59.999999
    ])
    ->get();

1 like

Shady Hesham

4 years ago

Level 1

@tykus thank you, it works well

Please or to participate in this conversation.