/PHP/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

10 votes157 views4 answers
Php artisan serve
PHP
0 vote161 views1 answer
Dateinterval php
PHP
1 vote177 views1 answer
Php code for getting the next day
PHP
0 vote180 views1 answer
Increas file upload db
PHP
6 votes219 views3 answers
Laravel bootstrap auth scaffolding
PHP Laravel
0 vote175 views1 answer
Automatic Subdomain with PHP
PHP
0 vote184 views1 answer
Php html template if conditions
PHP
0 vote213 views1 answer
Form submitting is not working in php
PHP
60 votes179 views4 answers
String to decimal php
PHP
33 votes221 views6 answers
Create migration command in laravel
PHP Laravel