Date format issue

https://www.w3schools.com/sql/func_mysql_date_format.asp

Or just store the dates in a format mySQL is happy with and create accessors/mutators for them.

use Carbon and you can manipulate your date however you want

use Carbon\Carbon;

$date = Carbon::parse($request->start_date);

You can accept inputs in various formats but you should always convert it to YYYY-MM-DD for use in your application and database. Not only is this what MySQL expects, but it's much easier to work with YYYY-MM-DD for comparisons.

For example, '16-12-2018' > '01-01-2019' which isn't valid.

Mysql expects YYYY-MM-DD HH:ii:ss format. Just store that way and you can format it how you want when displaying.

Let's say you have a model named MyModel and a datetime field called "mydate".

In the MyModel model, you can add

protected $dates = [
    'created_at',
    'updated_at',
    'mydate'
];
// need to include created_at and updated_at in addition to your custom fields

https://laravel.com/docs/5.6/eloquent-mutators#date-mutators

That will convert your mydate field to a carbon instance automatically.

Then in your views, you can

{{ $MyModel->mydate->format('d-m-Y') }}

to format it how you want to display it.