CODEWITHSUNDEEP
phplaraveldatelaravel-5php-carbon
Juliver Galleto
Juliver Galleto

Reputation: 9037

Carbon.php The separation symbol could not be found Data missing

First, I retrieve all the records,

//get inventory items
$inv = inventory::all();

and then I loop on the retrieved records and modify the created_at and updated_at data to make it more human readable date.

foreach($inv as $i){
    $i->created_at = date("M d, Y",strtotime($i->created_at));
    $i->updated_at = date("M d, Y",strtotime($i->updated_at));
}

but it returns me this error,

InvalidArgumentException in Carbon.php line 425: Unexpected data found. Unexpected data found. The separation symbol could not be found Data missing

any ideas, help, clues, suggestions, recommendations please?

here's my model

namespace App;

use Illuminate\Database\Eloquent\Model;

class inventory extends Model
{
    protected $table = "inventory";
    protected $primaryKey = "item_id";
    public $incrementing = false;

    public function profile(){
        return $this->belongsTo('App\profile','username');
    }
    public function inventory_images(){
        return $this->hasMany('App\inventory_images','item_id');
    }
}

and in blade, I can just use

{{ date("M d, Y",strtotime($i->created_at)) }}

{{ date("M d, Y",strtotime($i->updated_at)) }}

and it work just fine.

Upvotes: 13

Views: 76270

Answers (3)

pankaj
pankaj

Reputation: 1906

I was facing the same problem with the Excel upload. I tried many solutions but no solution was working in my case. After too much research I find a solution. I hope this answer will be helpful for others.

// Convert Excel date to Carbon date
        $carbonDate = Carbon::instance(Date::excelToDateTimeObject($row['dob']));

        // You can then format the date as needed
        $formattedDate = $carbonDate->toDateString(); // 'Y-m-d' format, for example


        dd(  $row['dob'], $carbonDate, $formattedDate );

Output

output of my solution

Upvotes: 0

Muhammed Nasar
Muhammed Nasar

Reputation: 41

So simple error please do like this

check your date format (d-m-Y) then use the same format

$shipDate = Carbon::createFromFormat('d-m-Y H:i',Carbon::parse($request->date)->format('d-m-Y') . " " . $request->time);

Upvotes: 3

Ohgodwhy
Ohgodwhy

Reputation: 50787

I think you're going about this the wrong way. The data in your database doesn't need to be more human readable, only the display that a human actually interacts with.

To solve this, we will create a custom accessor method that will apply to all calls for the created_at. You can recreate this for the updated_at.

public function getCreatedAtAttribute($timestamp) {
    return Carbon\Carbon::parse($timestamp)->format('M d, Y');
}

Then when you call $model->created_at your attribute will return in that format.

If for some reason you absolutely need the date stored in that format, then you need to add an attribute to your model telling it that the timestamp columns should be formatted according to a specific type, such as:

protected $dateFormat = 'M d, Y';

Sidenote
The reason that Carbon is involved is that it is applied to all of the columns generated by $table->timestamps(), so the created_at and updated_at columns.
Furthemore, if you add more columns in the model to the protected $dates = [] array, those will also automagically be handled by Carbon.

Upvotes: 17

Related Questions