Date field shown as -0001-11-30 00:00:00

Published 2 years ago by rikw

Hi,

I have a model and form which I cannot get right. My database fields are of type date and datetime. Both fields are added to the dates array. When I save the form with empty values the database stores as 0000-00-00 00:00:00. But the edit form then shows -0001-11-30 00:00:00. I just cannot get it right. Who can help me?

Cheers! Rik

selmonal

I think you should set the date column to be nullable! Then it will be fine.

rikw
rikw
2 years ago (1,490 XP)

Hi @selmonal, I had that. But submittting an empty field makes it store 0000-00-00 00:00:00 in stead of null. Is that to be expected?

The situation occures when I create a new record with only one field filled. Then the edit screen shows empty date fields. When I submit those fields things go wrong.

Please sign in or create an account to participate in this conversation.