Forum Filter record created_at specific year

rahmatawaludin

posted 10 years ago

Eloquent

Last updated 2 years ago.

rahmatawaludin

replied 10 years ago

Solution

Found it:

Model::whereBetween('created_at', array(Carbon\Carbon::createFromDate(2010, 1, 1)->toDateTimeString(), Carbon\Carbon::createFromDate(2012, 1, 1)->toDateTimeString()))->get();

Last updated 2 years ago.

felipepodesta

replied 10 years ago

This example uses Brazilian date format (d/m/Y).

$model = Model::with(['access'])
    ->select(['id','title','slug','created_at','status'])
    ->withTrashed();

$from = Carbon::createFromFormat('d/m/Y', Input::get('date'))
    ->startOfDay()
    ->toDateTimeString();

$to = Carbon::createFromFormat('d/m/Y', Input::get('date'))
    ->endOfDay()
    ->toDateTimeString();

$model = $model->whereBetween('created_at', [$from, $to]);

Last updated 2 years ago.