Date/time fields not populating in forms from queries

[Nocode101]

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
{{query4.data}}
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 {{ table1.selectedRow.data }}

thanks

[ScottR]

for that field Date, are you naming it correctly as date?

[Nocode101]

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

thanks

[ScottR]

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 {{self.id}}

[cperea]

Hey @Nocode101, could you share a screenshot of what your query4.data 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.