Unanswered

Modern Date Picker / UK date format

(11) Share

Report

Posted on by Interlock

From what I can see, the Modern Date Picker control is still unable to display a short date in anything other than US format, as in 02/29/2024. Most of the world, according to Wikipedia (https://en.wikipedia.org/wiki/Date_format_by_country), would write that date in the format 29/02/2024. So most of the world is unable to use the Modern Date Picker without some ugly workaround, such as overlaying a text label.

I've been waiting patiently for this support to be added, thinking that it would happen shortly after the control's introduction. But still, many months on, there's no sign of it, and no mention of it on a recent blog post: https://powerapps.microsoft.com/en-us/blog/recap-of-modern-controls-evolution-in-2023-and-a-glimpse-into-2024-innovations/.

To me, it would make sense to use the locale set by the browser (see https://www.localeplanet.com/support/browser.html) or the device (if using a mobile app) as the default format, and allow this to be overridden by the maker if they want to do that.

Am I missing something? Perhaps there's some way of persuading the Modern Date Picker to use UK format that I haven't found. (entering "dd/MM/yyyy" into the "Format" property would make sense to me, but that doesn't work)

Anyone got any insights on this?

Categories:

General Questions

All responses (7)

Answers (0)

Grzegorz_Łopata 2 on at

Like (0)

Report
Re: Modern Date Picker / UK date format

Hi!

I found a solution how to display UK date format (dd.mm.yyyy) in Modern Datepicker 🙂

You should use a classic datepicker, a modern datepicker and a label, then follow the below instructions:
Set FontSize property of Modern DatePicker to 0.1
Set DefaultDate property of Classic DatePicker to ModernDatePickerCanvas.SelectedDate
Set Format property of Classic DatePicker to "dd.mm.yyyy"
Set Text property of Label to Text(ModernDatePickerCanvas.SelectedDate, "dd.mm.yyyy")
Place a text label in the Modern DatePicker
Set Visible property of Classic DatePicker to false
Now You can Patch this field:

Patch(Source, {ColumnName: ClassicDatePicker.SelectedDate})

This is the result:
Mike_Tuszynski 3 on at

Like (0)

Report

Re: Modern Date Picker / UK date format

I used this and it works as was expected. Thanks a lot for this solution 🙂 ps. generally it's European format 🙂
Grzegorz_Lopata 4 on at

Like (1)

Report

Re: Modern Date Picker / UK date format

.
LucyCC 95 on at

Like (3)

Report

Re: Modern Date Picker / UK date format

I can't believe that they've DISABLED the format option for classic controls when you've modern controls enabled. This is bizarre and crazy making. It's almost like Microsoft are on a mission to spread the US date format!
WillPage 1,881 on at

Like (0)

Report

Re: Modern Date Picker / UK date format

The worst thing is if you have modern controls enabled, even the "classic" date picker loses the ability to set the date format.
timl 34,955 Super User 2025 Season 1 on at

Like (1)

Report

Re: Modern Date Picker / UK date format

Hi @Interlock

I agree - I'm in the UK. I've added my feedback. Perhaps MS might prioritise this higher if enough people do the same.
WarrenBelz 146,700 Most Valuable Professional on at

Like (9)

Report

Re: Modern Date Picker / UK date format

Hi @Interlock ,

I agree as below and Format does not allow "dd/mm/yyyy" like a classic control (I just tested it). If you look down at the responses in this blog from @mdevaney , you will see that it is not currently supported. I have not moved to any Modern controls currently as they do not do anything really useful new, but more importantly have a lot of shortcomings such as this.