Modern Date Picker / UK date format

[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-.... 

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?

[WarrenBelz]

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.

[timl]

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.

[WillPage]

The worst thing is if you have modern controls enabled, even the "classic" date picker loses the ability to set the date format.

[LucyCC]

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!

[Grzegorz_Lopata]

.

[Mike_Tuszynski]

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

[Grzegorz_Łopata]

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:

1. Set FontSize property of Modern DatePicker to 0.1
2. Set DefaultDate property of Classic DatePicker to ModernDatePickerCanvas.SelectedDate
3. Set Format property of Classic DatePicker to "dd.mm.yyyy"

4. Set Text property of Label to Text(ModernDatePickerCanvas.SelectedDate, "dd.mm.yyyy")

5. Place a text label in the Modern DatePicker

6. Set Visible property of Classic DatePicker to false

Now You can Patch this field:

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

This is the result: