Unanswered

Date fields displaying US format for some users

(0) Share

Report

Posted on by Chris1968

1,146

Hi,

I've seen previous messages relating to this issue but these are dating back to 2021 or before.
Solved: Date and Number Format suddenly US/American in all... - Power Platform Community (microsoft.com)

Some of my users are seeing US format style dates in the app where some others, in the same team, using the same app are seeing the dates, correctly in UK format.

Their respective PC / Laptops are all configured to

(Dates differ as raised this on the 25/01/2023, US format screen shot sent on the 24/01/2023)

Is anyone else seeing this and how can it be resolved it as it's messing up some of our records that use flows

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
Hi @ClarkyPA365 ,

Set the Format property of the Date Pickers to

"dd/mm/yyyy"

and it will solve the issue

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Chris1968 1,146 on at

Like (0)

Report

Hi @WarrenBelz

Thanks for the solution.

Just seems a bit weird why this is happening and I need to do this for all the date fields included in the apps.??

Just want to run this past you as received some more information from the users.

It seems that depending where they are at either work or home, using a company device with a VPN to access out network, depends if they see the date in the UK format.

One says if they are at work it's fine but not if at home and another says it happens the other way for them?? Very strange.

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @ClarkyPA365 ,

I get the same thing on mobile devices and different browsers - as a matter of practice, I format all Date Pickers.

Was this reply helpful? Yes No
Chris1968 1,146 on at

Like (0)

Report

Hi @WarrenBelz

Suppose it eliminates this issue from the start.

I'll do that from now on. 👍

Was this reply helpful? Yes No
JamesSnaps 187 on at

Like (0)

Report

Just thought I'd add that we've also seen any unformatted dates do this too. Seems like there may be a server-side issue that's caused formatting to revert to US date format. So now I begin the long process of updating any that aren't formatted to deal with it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Some of my users are experiencing this issue too. Raised a call with MS. No resolution yet.

Was this reply helpful? Yes No
Chris1968 1,146 on at

Like (0)

Report

Hi Waren,

I was wondering if you can assist with the issue I have with the dates, not displaying properly again for certain users, in a gallery??
The gallery should bring back a list of people whose birthday it is in Jan
there is also a gallery that show birthdays for the next month. This is showing the same dates as in the image below
Should look like this

Formula> Text>
Sort(Filter(Volunteers, IsBlank('Leaving Date')
&& !IsBlank('Date of Birth')
&& //(
Mid(Left(Text('Date of Birth'),Len(Text('Date of Birth')) - 5),4,2) = Mid(Left(Text(Now()),Len(Text(Now())) - 5),4,2)
//|| Mid(Left(Text('Date of Birth'),Len(Text('Date of Birth')) - 5),4,2) = Mid(Left(Text(DateAdd(Now(),1,Months)),Len(Text(Now())) - 5),4,2)
//)
), Mid(Left(Text('Date of Birth'),Len(Text('Date of Birth')) - 5),1,2), Ascending)
// GETTING MONTH NUMBER OF DOB AND NOW

Formula for Date
Text(ThisItem.'Date of Birth',"dd-mmm-yyyy")

Is as simple as changing the format to "dd/mm/yyyy"??

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @ClarkyPA365 ,

Short answer - yes I believe so.

Was this reply helpful? Yes No