I am posting a problem for once and this one has us baffled.
We have a group of PCs (in the same network and SOE) that display the date of October 4 2020 as October 3 in Power Apps no matter what we do. This is happening over multiple apps on multiple SharePoint lists on multiple controls including gallery labels and form date pickers. SharePoint is correct at October 4 and opening on an iPad or many other PCs on the same app (including mine, but I work remotely) it shows October 4 2020.
Fairly extensive testing establishes the following (on the affected PCs): -
This is not a time zone / UTC issue - we are UTC + 10 and it happens any time of day.
There has got to be an explanation for this - has anyone struck anything like this before?
Don't ya just love the odd ones?!
So, are you absolutely sure it's not time zone related? Is there any way you can change the date display to also display the time? I would be curious to see if it actually displays 12:00 AM or some hour prior to it (i.e. the day before)
Just a thought to try and troubleshoot a little.
Hi @RandyHayes ,
Thanks and I am going to head down the time path when I can get onto one of the PCs.
What is weird is that the other 365 days of the year (2020 is leap year) work perfectly. We tested the time zone theory at 18:10 yesterday (when it was Tuesday in everywhere but Hawaii and Tahiti), still the same issue.
I'm intrigued!!! Please share any testing you find. I'd be happy to try and duplicate anything you need an extra set of eyes on.
This just gets curiouser and curiouser . . . here is the testing so far.
Now I thought I would go into the office and try and eliminate some things - so
What else can possibly be the variable here?
That is bizarre! I love tracking those kind of things down - I wish I could make it happen here.
Some of my next steps would be to really examine the time component of the date. I would really want to know what does October 3 and October 4 really represent? Oct 4 12:00 AM or Oct 3 11:00 PM or just what does the time component of the date have?
Then, since it is isolated to only certain devices, I would take a deep look at the regional settings of the devices. And if they are server derived (the authoritative time server), what is that set up like and does it have an issue?
Finally, I would narrow down with a new app that only demonstrates the issue (i.e. only writes the date and reads it back) and then use the data monitoring/tracking tools to see if there is any anomaly in the data going to or coming from the list.
I also did not include tried different browsers as well and that it all works perfectly on my personal laptop.
I had a look at the Regional Settings and they are UTC + 10.
I will try the new app, but there are three others, one of which was written 2 years ago that it does the same thing on.
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!