Currently, I am working on a Laravel Project and have a data table displaying various data. One of the pieces of information displayed is the date, which is in the format YYYY-MM-DD as stored in the database. However, I would like to present it in either 04 Feb 2020 or 04-02-2020 format.
Below is the code snippet from my View:
var table = $('.data-table').DataTable({
processing: true,
serverSide: true,
ajax: "{{ route('home.index') }}",
columns: [{
data: 'DT_RowIndex',
name: 'DT_RowIndex',
orderable: false,
searchable: false,
},
{
data: 'title',
name: 'title',
orderable: false,
},
{
data: 'content',
name: 'content',
orderable: false,
},
{
data: 'progress',
name: 'progress'
},
{
data: 'status',
name: 'status'
},
{
data: 'finish_date',
name: 'finish_date'
},
{
data: 'action',
name: 'action',
orderable: false,
searchable: false
},
]
});
Here is an excerpt from my controller:
if ($request->ajax()) {
$data = Post::where('user_id', Auth::id())->latest()->get();
return Datatables::of($data)
->addIndexColumn()
->addColumn('action', function ($row) {
$btn = '<a href="javascript:void(0)" data-toggle="tooltip" data-id="' . $row->id . '" data-original-title="Edit" class=" edit btn btn-primary btn-sm editProduct"><span class="fas fa-pen"></span></a>';
$btn = $btn . ' <a href="javascript:void(0)" data-toggle="tooltip" data-id="' . $row->id . '" data-original-title="Delete" class="btn btn-danger btn-sm deleteProduct"><span class="fas fa-trash"></span></a>';
return $btn;
})
->rawColumns(['action'])
->make(true);
}
return view('index');
I am wondering if there is a way to customize the date format for display?