Date field must cast to 'date' in Eloquent model

Question

Hi I'm using laravel nova for create an admin panel. And I'm trying to use Date Field.

This is my migration,

$table->date('day')->nullable();

This is my my nova resource,

public function fields(Request $request)
    {
        return [
            ID::make()->sortable(),
            Date::make(__('Day'), 'day'),
        ];
    }

This is my model,

class Menu extends Model
{
    use HasTranslations;

    public $translatable = ['name','description'];

    protected $fillable = [
        'name','description','typology', 'cost', 'day', 'active', 'buffet'
    ];

This is my error,

Date field must cast to 'date' in Eloquent model.

Do I need to do anything in resource ?

score 31 · Accepted Answer · edited Mar 12 '19 at 22:08

31

In your model class you just need to add the following lines which describe to laravel that you must cast the day field into a date object (Carbon):

//Casts of the model dates
protected $casts = [
    'day' => 'date'
];

Check here someone has the same issue.

EDIT:

I have seen that your day column is set to nullable i think that your field Nova should be to like in this post :

public function fields(Request $request)
    {
        return [
            ID::make()->sortable(),
            Date::make(__('Day'), 'day')->nullable(),
        ];
    }

And we need to change the model like this,

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

edited Mar 12 '19 at 22:08

Carcigenicate

43,494
9
68
117

answered Mar 12 '19 at 09:16

Julien METRAL

1,894
13
30

1

really sorry I did that but still issue happens :'( and do I need to add carbon? – vimuth Mar 12 '19 at 09:24
:'( still it appears :'( – vimuth Mar 12 '19 at 09:36
can you post the model too ? don't you have other fields with a date ? – Julien METRAL Mar 12 '19 at 09:37
Thanks a lot bro I found a little missing piece and added it :). I up voted and selected as correct answer it would be great help if you can approve the edit :) – vimuth Mar 12 '19 at 09:54
1

No problem bro ;) – Julien METRAL Mar 12 '19 at 09:55

Date field must cast to 'date' in Eloquent model

1 Answers1