cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Field
Helper V
Helper V

Change date format of a Parent.Default

Hello, 

 

I am using a Date Field on my powerapp. For some reason, the app is putting the Date Format in "mm/dd/yyyy" when in reality i wanted to put "dd/mm/yyyy".

 

When i use the following code in the "Default Date" [ If( SharePointForm1.Mode = New; "";Text(Parent.Default,"dd/mm/yyyy")) ], this doesn't change the date format, but rather adds more years into the date. The date i have in the list is 28/01/2021, but when i add this code, the date for some reason changes to 14/1/2023. 

 

Does anyone know how to solve this issue?

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User
Super User

@Field 

Put your DefaultDate back to Parent.Default and then change the Format property of the DatePicker to the following:

"dd/mm/yyyy"

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

6 REPLIES 6
RandyHayes
Super User
Super User

@Field 

Put your DefaultDate back to Parent.Default and then change the Format property of the DatePicker to the following:

"dd/mm/yyyy"

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
chmielos
Frequent Visitor

Since yesterday, all my applications have changed the date format to the American one, i.e. in the edit mode I have good dd.mm.yyyy but in the production mode for the client the date is mm / dd / yyyy. The change applies to all apps, even those that haven't been touched for several weeks. The same with numbers, you need to put a period instead of a comma. I checked the browser settings and the same effect everywhere in different browsers. Do you have that too? Does anyone have the same and know more about this error?

I have the same problem. In application edit mode is OK. I'm from Poland.

 

 

Hi @KonradPogodz and @chmielos ,

 

I had the exact same problem, and this happened after new year came in. We never made changes to the date, but on the editor it looks fine, but when watching the display it has mm / dd / yyyy. I had to do this fix.

 

Can one of the devs explain this behaviour? 

AdrienB
Frequent Visitor

Hi,

 

I also have the same problem: in all my apps date and number switched to the american format wich cause some of my apps to stop working.

 

In the editor, everything is fine. 

 

What can we do about it?

 

Thanks

@Field 

It's definitely something that has either changed or is a bug to be fixed.  But in the meantime, setting the controls specifically to specify the locale will work.

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,112)