/PHP/Laravel/Laravel datatable format date column

Laravel datatable format date column

$projects = Project::select('id', 'name', 'date_start', 'date_end');
return Datatables::of($projects)
  ->editColumn('date_start', function ($request) {
    return $request->date_start->format('Y-m-d'); // human readable format
  })
  ->editColumn('date_end', function ($request) {
    return $request->date_end->format('Y-m-d'); // human readable format
  })
  ->filterColumn('date_start', function ($query, $keyword) {
    $query->whereRaw("DATE_FORMAT(date_start,'%Y-%m-%d') like ?", ["%$keyword%"]); //date_format when searching using date
  })
  ->filterColumn('date_end', function ($query, $keyword) {
    $query->whereRaw("DATE_FORMAT(date_end,'%Y-%m-%d') like ?", ["%$keyword%"]); //date_format when searching using date
  })
  ->make(true);

Source: datatables.yajrabox.com

Similar codes

11 votes181 views3 answers
Blade condition if else laravel
PHP Laravel
0 vote195 views1 answer
Laravel carbon first day of month
PHP Laravel
0 vote181 views5 answers
Laravel authentication in laravel 8
PHP Laravel
0 vote226 views1 answer
Laravel where on relationsship column
PHP Laravel
11 votes231 views3 answers
How to make validate error when password doesnt match with password confirm laravel
PHP Laravel
0 vote189 views2 answers
Laravel db insert get last id
PHP Laravel
50 votes266 views6 answers
Add column in laravel migration
PHP Laravel
19 votes194 views6 answers
Laravel Route Group
PHP Laravel
9 votes205 views3 answers
Laravel enum migration
PHP Laravel
4 votes213 views2 answers
Laravel order by random
PHP Laravel