© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
FilamentF
Filament•3y ago•
4 replies
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)),
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)),
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
datetime
cast on the model?
Jump to solution
Filament banner
FilamentJoin
A powerful open source UI framework for Laravel • Build and ship admin panels & apps fast with Livewire
20,307Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Format datetime picker
FilamentFFilament / ❓┊help
2y ago
DateTimePicker Formatting
FilamentFFilament / ❓┊help
2y ago
SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value:
FilamentFFilament / ❓┊help
3y ago
DateTimePicker 12 hour clock format
FilamentFFilament / ❓┊help
3y ago