Date field error while updating in DB

💬 Queries and Resources
1

Hi there, I don't know why my date field gives me an error when I sent the date field as empty for updating in retool database. I apply {{update_shipping_date.value}} in GUI mode.

2

Hi @afaq_mehmood I think when you update your date field as empty in database. Database does not accept it. So, you have to send your date field value as null when the date field does not contains any date. Try this out.

{{update_shipping_date.value,trim() != "" && update_shipping_date.value != "Invalid date" ? update_shipping_date.value : null }}

In my last project I have got this error you can try this. This will absolutely work. I also manage this query according to your field name.

3

I apologize, i got some mistake in query let me correct this.

{{update_shipping_date.value.trim() != "" && update_shipping_date.value != "Invalid date" ? update_shipping_date.value : null }}

4

@ahsan_ali_shah1 I will try this

5

Thanks @ahsan_ali_shah1