cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BartaJaroslav
Level: Powered On

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]dd.mm.yyyy") - on screen is with time part

10 REPLIES 10
BartaJaroslav
Level: Powered On

Re: Date, DateTime, SQL AZURE

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)

PowerApps Staff AndyPennell
PowerApps Staff

Re: Date, DateTime, SQL AZURE

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.]

PowerApps Staff erga
PowerApps Staff

Re: Date, DateTime, SQL AZURE

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. 

 

Thanks,

Eric. Software Engineer. PowerApps Staff

PFalcy
Level: Power Up

Re: Date, DateTime, SQL AZURE

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

arnonel
Level: Powered On

Re: Date, DateTime, SQL AZURE

Any news on this please?

Meneghino
Level 10

Re: Date, DateTime, SQL AZURE

Is there any news on this issue?

Please?

 

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!

Wil
Level: Powered On

Re: Date, DateTime, SQL AZURE

Hi Eric,

 

It has been more than a year now.

 

Any news about the fix?

 

Thanks

PhilD
Level 8

Re: Date, DateTime, SQL AZURE

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...

 

 

Meneghino
Level 10

Re: Date, DateTime, SQL AZURE

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 108 members 4,920 guests
Please welcome our newest community members: