Could not parse '29/10/1948': Failed to parse time string (29/10/1948)

i try to insert '29/10/1948' in date field, but i got this error Could not parse '29/10/1948': Failed to parse time string (29/10/1948) at position 0 (2): Unexpected character

in model i use casts

protected $casts = [ 'in_date'=>'date'];

and in insert i try

$model->in_date = \Carbon\Carbon::parse($request->in_date)->format('d-m-Y');

but not working

LaryAI

2 years ago

Level 58

The error message suggests that there is an issue with parsing the date string '29/10/1948'. The format 'd-m-Y' is being used to parse the date, but the actual format of the date string is 'd/m/Y'. To fix this, you need to update the format used in the parse method.

Here's the updated code:

$model->in_date = \Carbon\Carbon::createFromFormat('d/m/Y', $request->in_date)->format('Y-m-d');

This code uses the createFromFormat method of Carbon to parse the date string with the correct format 'd/m/Y'. Then, it formats the date as 'Y-m-d' before assigning it to the in_date attribute of the model.

Make sure to replace $request->in_date with the actual variable that holds the date string in your code.

click

2 years ago

Level 35

29/10/1948 is not a normal (valid) date format.

There are 3 options:

You should enter your date as mm/dd/yyyy so 10/29/1948
Use a more standard format, something like: 'dd-mm-yyyy' so 29-10-1989 or any other standard supported format.
You specify the date format yourself Carbon::createFromFormat('d/m/Y', '29/10/1948');

Snapey

2 years ago

Level 122

@click its a standard format if you don't live in the US !

click

2 years ago

Level 35

@Snapey It is not with / as a separator. It is with a - as a separator. https://www.php.net/manual/en/datetime.formats.date.php

Snapey

2 years ago

Level 122

@click interesting that the majority here https://en.wikipedia.org/wiki/Date_format_by_country use the / as the separator (including the US) with most countries preferring DMY format over MDY (US is the outlier here)

Snapey

2 years ago

Level 122

Always try and use createFromFormat.

Carbon can't know how to parse 03/04/2023 for example (3rd April or 4th March?)

Please or to participate in this conversation.