Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Date, DateTime, SQL AZURE

WEBVERSION,Czech localization,


If I create field type Date in SQL server - i can not see value in PowerApps

If I create field type DateTime in SQL server - I can see value, but I can not change format over

Text(Parent.Default;"[$-cs-CZ]") - on screen is with time part

Helper I
Helper I

WebVersion, SQL Azure, Czech local

If I change DataCard with DateTime field on TextView I can seek DAteTime on scren

but if I change on DateTime picker I get error - Wait for operator for example +,*,&&

In Update is

DateValue2.SelectedDate + Time(Value(HourValue2.Selected.Value);; Value(MinuteValue2.Selected.Value);; 0)

Those double semi-colons should be single semi-colons (in Czech, and other languages that use comma as a decimal point). There must be a bug somewhere that generated this formula.


[In languages that use period as a decimal point, function parameters are separated with commas instead.]

Power Apps
Power Apps

There is currently a known issue with the Date field type for SQL Azure where the Date will not display on PowerApps. Our team has identified the issue and the fix should be out soon (within the next release or two). Please use DateTime in the meantime. 



Eric. Software Engineer. PowerApps Staff

Do you have a solution pending the correction of the bug?

Any news on this please?

Community Champion
Community Champion

Is there any news on this issue?



To be more precise:  when patching a date column with the

UpdateContext({MyPatch: Patch(MyTable, MyRecord, {DateColumn: Date(1970, 1, 4))})

Then the column in Azure SQL DB is updated with the correct value, but MyPatch.DateColumn is blank!

Frequent Visitor

Hi Eric,


It has been more than a year now.


Any news about the fix?



Kudo Kingpin
Kudo Kingpin

So anything involving dates is a no-go in PowerApps with SQL server or Azure and anything using SharePoint is subject to the 2000 row limit... so after development a handful of apps my question is... what am I supposed to use this for in a large organization?


Two years later and there is still no way to use dates with a SQL server data source? I just can't waste anymore time on this...



Community Champion
Community Champion

Helpful resources

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,234)