cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
paNewby
Helper III
Helper III

How do I get my dataform to display dates in DD/MM/YYYY format?

I have set my computer Region/Date to Australia DD/MM/YYYY format. I have set Sharepoint region to the same so my Sharepoint list displays in that format. I have created a PowerApp that insists on displaying dates in MM/DD/YYYY format. How do I change it?

38 REPLIES 38
AlexKeil
Advocate II
Advocate II

Okay so i found a way to do this, if you change the 'format' property from something like 'DateTimeFormat.ShortDate' to just "dd/mm/yyyy" it will change it. I found that even when using TEXT(<field>, "dd/mm/yyyy") if the format property shows shortdate, or longdate or anything like that, it will use the browser defult.

Thank you for this. I have just tried it and low and behold it works, I have a Europe/UK date format in the date picker. 

I spent hours looking for complicated solutions and this appears to do the trick.

Genius.

Thanks for your help.

Anonymous
Not applicable

works perfectly! thanks

DavidVidal
Regular Visitor

Hello,

i have managed to do that by editing the "Format" like that

 

Text([YourDateFieldName].SelectedDate,"[$-en-US]dd/mm/yyyy","en-GB")

A slightly different use case here, but it is somewhat relevant to this thread.  If you'd like to apply date/time settings to a field in a gallery, you can use:

 

 

Text(ThisItem.YourDateFieldHere,"[$-en-US]dd/mm/yyyy")

 

 

Thanks. It worked 😄

MarkyMark8869
Frequent Visitor

Change the Language in the Datacard to 'en-GB'

Wolf_c
Frequent Visitor

so simple and smart! thank you

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,336)