Level 104
You can use Carbon to parse the date and pass it to the database in the required format:
// assuming the data comes from the Request object, change if appropriate
$invduedate = Carbon::createFromFormat('d/m/Y', $request-> invduedate);
Apr 30, 2018
3
Level 1
incorrect date value
hi
I am facing a issue called incorrect date value in controller file
Invalid datetime format: 1292 Incorrect date value: '10/10/2018' for column 'invduedate' at row 1 (SQL: insert into invoice(custid,compid,invduedate) values('5','1','10/10/2018'))
i want to know is there any function for this?
Level 1
$duedate=Carbon::createFromFormat('d/m/Y', $req->input('invduedate'));
its saying data missing
Level 104
What does $req->input('invduedate') give you? I would expect that exception if there was an empty, null, or incomplete date (e.g. 10/2018) that did not match the given format
Please or to participate in this conversation.