FilamentF
Filament•3y ago
Pablo Torres

DateTimePicker: Error - Invalid datetime format

Hi,
I have column "payment_due_at" , $table->dateTime('payment_due_at')->nullable();

My form:

Forms\Components\DateTimePicker::make('payment_due_at')
    ->displayFormat('M j, Y')
    ->format('Y-m-d h:m:s')
    ->maxDate(now()->addDays(90)),

When submitting I get:

SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '1690542420' for column 'payment_due_at' at row 1

I have also tried:

Forms\Components\DateTimePicker::make('payment_due_at')
    ->displayFormat('M j, Y')
    ->maxDate(now()->addDays(90)),


Same error

Any suggestions, please?
Thank you
Solution
Do you have a datetime cast on the model?
Jump to solution
Was this page helpful?