cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Wolfmeyn
Helper II
Helper II

Change Date from MM/DD/YYYY to DD/MM/YYYY

Hello i would like to change the date format both in the date picker and in the text above.

 

In the text above im just using today() for now 

Wolfmeyn_1-1663141913723.png

 

I want it to be DD/MM/YYYY

 

 

 

 

9 REPLIES 9
NativeNass_
Helper I
Helper I

Hi

 

Use, Text(today(), "DD/MM/YYYY")

 

And in the datepicker, you change the 'Language' under Advanced properties to e.g. 'en-GB'

NativeNass__0-1663143887081.png

 

Does this solve your problem?

This part with text field did not work

Wolfmeyn_0-1663147140944.png

 

but the part with the datepicker worked well

@Wolfmeyn 

You need to close the brackets on the 'Text()', so add another ')' at the end.

 

Does it work now?

Pavel_Sheludkov
New Member

For the datepicker, you can also put "dd/mm/yyyy" into the Format property.

use it all the time, works like a charm.

@Pavel_Sheludkov  

indeed, but in the past I came across issues when building a complex financial app, and calculating whether some stuff happened in specific financial quarters.

 

This was solved by aligning the 'Language' of the datepickers instead of the format of them.

 

There were also issues with browser settings and stuff, which were then overruled by the datepicker 'Language'.

- All the datepickers within your calculations need the same 'Language' property then.

 

But maybe that's resolved to this day.

Thanks for sharing, good to know! 
I haven't come across this scenario yet, can be useful to consider.

Wolfmeyn_0-1663149860861.png

with closed brackets it showed this hmm ? 

 

@Wolfmeyn 

 

Don't use capital letters and your formula will work 🙂

Apparently it's case sensitive

NativeNass__0-1663150127453.png

 

Raksh1Wadel
Resolver I
Resolver I

Hi,

You can refer to this link. It will help you resolve your issue.

Power Apps Guide - Dates - How to convert dates from MM DD YYYY to DD MM YYYY and vice versa - Power...

 

If this post helps, then please consider Accept it as the solution to help the others and consider giving it a "Thumbs Up."

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.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

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 (4,043)