Return NULL instead of "Invalid date"

I have some Datepicker widgets.

If there is no date selected in the Widget, it returns “Invalid date”. Is there an easy way to return an NULL.

So i want to Do an insert into an Mysql DB (dateime Column), which allows NULL. If an Date is select it works fine, but “invalid date” is not a accepted value.

thx
Franz

Hello Franz! You can try to use {{ DatePicker1.selectedDate || null}}. This way, if there is no date selected in the DatePicker, it will insert null.

1 Like

Hi Amelia, oh i didn’t expect it to be so easy. thank you !