Json column - Date field must cast to 'date' in Eloquent model

Question

I have a laravel nova panel like below. Im trying to use a Date field like below:

new Panel('Suggestions', [
    Flexible::make('Suggestions')
        ->addLayout('Suggestions', 'suggestion', [
            Text::make('Title'),
            Textarea::make('Message'),
            Date::make('Date', 'date')
        ])
        ->button('Add Suggestion'),
]),

However it shows this error:

{message: "Date field must cast to 'date' in Eloquent model.", exception: "Exception",…}
exception: "Exception"
file: "/var/www/html/vendor/laravel/nova/src/Fields/Date.php"
line: 41
message: "Date field must cast to 'date' in Eloquent model."

I have in the model the casts property like this:

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

Do you know what can be the issue?

I don't have a date field on the database table relative to the model. I just have a suggestions json field that has a lot of columns including the "date" column/key, probably that's the issue. Do you know how to solve this issue in this scenario? Thanks

NoahNxT · Accepted Answer · 2022-05-10 14:17:09Z

2

Add this to your casts instead of 'date' => 'date', this solved for me the issue.

protected $casts = [
        'flexible-content' => FlexibleCast::class
    ];

Another options is resolving it and converting it to a MomentJS format which also works fine:

DateTime::make('Date')
   ->format('DD/MM/YYYY HH:mm')
   ->resolveUsing(function ($value) {
           return $value;
   }),

source: https://github.com/whitecube/nova-flexible-content/issues/171

edited May 10, 2022 at 14:17

answered May 10, 2022 at 14:04

NoahNxT

1561 silver badge12 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Bernard Over a year ago

Thanks! Like that it doesn't show the error. Do you know how to change so it have this format "YYYY/MM/DD" and to show the current date by default? Like this is not working : Date::make('Date') ->format('YYYY/MM/DD') ->resolveUsing(function ($value) { return $value; }), ]).

NoahNxT Over a year ago

As per documentation (nova.laravel.com/docs/1.0/resources/fields.html#datetime-field) you could just remove the format because it will default format it to that format, otherwise you could look at Moment.js formatting rules momentjs.com/docs/#/displaying/format because nova dates standard uses MomentJS for formatting dates

Bernard Over a year ago

Thanks but without the format it shows with this format "dd/mm/yyy". And the field shows "dd/mm/yyyy" instead of the current date by default.

NoahNxT Over a year ago

You should take a look then at the MomentJS formatting rules I gave you above, and otherwise you could still transform you date in the resolveUsing with carbon to the needed format. Maybe not the cleanest fix but that should also work.

Bernard Over a year ago

Thanks, but can you explain how it would work in the resolveUsing()? To have the "yyyy/mm/dd" format?

|

Lonare · Accepted Answer · 2022-09-25 19:36:19Z

0

First, I guess you need to rename your db field to something else.

And then

You need to cast your db field into your model like this:

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

answered Sep 25, 2022 at 19:36

Lonare

4,8012 gold badges56 silver badges56 bronze badges

Collectives™ on Stack Overflow

Json column - Date field must cast to 'date' in Eloquent model

2 Answers 2

7 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related