cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Found bug -- date fields not displaying properly

Hello,

 

I have a date field in my entity.  When I choose a date in my form and display it in a data table, it shows up correctly.  However, if I look at it in the CDS it shows up as 1 day earlier than the date I selected.  How can I fix this?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: Found bug -- date fields not displaying properly

I was able to fix this issue by going to  File -> App settings -> Experimental features -> Delayed load   and turning delayed load to off.

6 REPLIES 6
PowerApps Staff CWesener
PowerApps Staff

Re: Found bug -- date fields not displaying properly

 

Hi @Anonymous - can you confirm when you created your environment and could you possible include a screen shot of the two dates you're comparing?

 

There are known differences in running an app versus the portal where the date can be converted to the users local timezone, but I'd like to confirm its the same issue.

Thanks,
Clay.
Anonymous
Not applicable

Re: Found bug -- date fields not displaying properly

Hi @CWesener,

 

The environment was created on 4/2/2018.

 

I have attached two images: one that shows my form in view mode with the correct Start Date that I selected from a date picker when I created the form (7/15), and one that shows how the Start Date shows up un the entity (7/14).

 

 

Thanks!

 

 

 

 

Anonymous
Not applicable

Re: Found bug -- date fields not displaying properly

Hi @CWesener,

 

In the CDS under the field property for my "Start Date" field, there is a dropdown called Behavior.  I switched this from "User Local" to "Date Only".  This fixed the issue and now the date is being saved properly.  However, once I changed the Behavior to be "Date Only", I now receive the error message "An entry is required or has an invalid value" on my Start Date field when I run the app in play mode.  This error does not occur when I run the app in edit mode.  Can you help me figure out why this is happening?

 

Thanks!

Anonymous
Not applicable

Re: Found bug -- date fields not displaying properly

I was able to fix this issue by going to  File -> App settings -> Experimental features -> Delayed load   and turning delayed load to off.

Highlighted
PowerApps Staff CWesener
PowerApps Staff

Re: Found bug -- date fields not displaying properly

Thanks @Anonymous. Adding @GregLi from our team to see what might be causing the underlying issue.

Thanks,
Clay.
MahakMM
Level: Power Up

Re: Found bug -- date fields not displaying properly

Hi @CWesener 
The CDS entities save data in UTC time, where as we have setup time zone as AEST i.e. +10:00 UTC, hence when we push the data to D365 for Finance and operatiosn it throughs an error the valid to and fron date time fields are invalid.

This still needs to be fixed and unfortunately we are approaching go live date, but this bug is giving us problems, any way out or temporary solution suggestions will be appreciated

Thanks

Mahak

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

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

Users Online
Currently online: 444 members 5,342 guests
Please welcome our newest community members: