Date/time fields not populating in forms from queries

Mysql backend;
I have a column defined as date;
created a form for testing just with the date column

When I use a query as source for form, the date is blank/null
when I mouse over data source for the form, I can see the date value for deadline date; but the form shows blanks

Now I created a table for the data and pointed the form to selected row in data as source then it works {{ }}



for that field Date, are you naming it correctly as date?
Screenshot 2023-12-27 at 12.16.58 PM

Screenshot 2023-12-27 at 12.16.51 PM

Screenshot 2023-12-27 at 12.16.43 PM

yes; as soon as I change the data source to selected row it works without any changes
really weird

deadline is the mysql column name for the date field


I don't understand why you have the Placeholder value populated and the Default value to new Date()
The field name is date1, so perhaps name it deadline instead and the form data key should then be be {{}}

Hey @Nocode101, could you share a screenshot of what your looks like? Looks like your From data key is "deadline" so your query that populates the form should return something along the lines of {date1:1984-02-23T04:00:00.000Z} in order to populate your date component. I tested this on my end and it seems to be working as expected.