SQL Date Not Showing from On Premise Database

[LostHighway72]

I have created a on premise database and have connected to it no problem at all.  The issue is with a date type field.  I have created an App from existing data which again is all good.  When I run the app and create a new record the date time picker appears and I can choose a date, however when the record is saved the date is not displayed on the form.  When I query the SQL database the record has written successfully.  Can someone please help explain why the date is not being returned, the rest of the fields for the record display no problem.

On a side note the date time picker only seems to work for this App through the browser, not on a tablet or mobile device.

[v-micsh-msft]

Hi LostHighway72,

Thanks for letting us know this.

This should be related with the Time Picker control, please take a look at the thread below:

Datepicker created in Sharepoint not working in Android & IOSapp ? / Sample working

The reply from PowerApp Staff CarlosFigueira:

"

Thank you for reporting this issue. We've identified a fix that will be going out in in an upcoming release.

As a temporary workaround, you can select the date picker control in the generated app, and set its "IsEditable" property to false; that should make the calendar show up in the devices.

"

Check to see if the workarounds would help.

And I will report this from my side once this issue has been confirmed.

Regards

[LateNightDBA · Accepted solution]

I had simliar issue with SQL server in cloud (not SQL Azure) - Issue workaround ensure datatype is datetime not date 😞 same issue with smaller integer types.

[LostHighway72]

Works well, thank you.

[goaltender36]

I am having the same issue when I connected to Azure SQL. So you are saying I should change my data type in SQL to date time instead?