Possible Date Picker Bug?

Wappler Version : 2.1.5
Operating System : Mac OS

Expected behavior

What do you think should happen?

I have a datepicker on a form that works fine. My expected behaviour would be that if no date is picked it would leave the data in that field empty.

Actual behavior

What actually happens?

If you do not select a date it enters 0000-00-00 as the date in the table.

How to reproduce

Add a datepicker to a form and submit form without picking a date.

@brad,

I had the same experience. When I set the data field in the database to accept null values, it would produce an undefined entry in the data picker.

So my solution was to not accept null values in the data field, which resulted in the 0 database entries you are seeing.

However, the end user should not see the 0’s. I don’t see them on my front end.

It shows as January 1, 1900 in the front end.

Set a condition in your update query

This basically says “On condition that there is something in this field then update this field, otherwise ignore it”.

2 Likes

Thanks @UKRiggers! That solution worked perfectly!

1 Like