Answered

Date format incorrect from date picker

(0) Share

Report

Posted on by CU16050836-1

116

I recently posted a query regarding replacing the default date picker so that the user didn't have to click the OK button:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Date-picker-custom-control-query/m-p/1379549#M358765

The solution I was provided was based upon copying the datepicker from PowerApps in Teams to regular Power Apps, and for the most part works fine. I just have one glitch.

In my part of the world we use the dd/mm/yyyy date format. When I preview the app in Power Apps Studio, the date picker displays the date in the correct format:

However, when I publish the app, it changes it to US date format (mm/dd/yyyy):

Any ideas how I can fix this?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!

@rdorman
Try this
https://powerusers.microsoft.com/t5/Building-Power-Apps/Change-date-format-from-mm-dd-yyyy-to-dd-mm-yyyy-in-Powerapps-in/td-p/1231526

You may need to format in Teams first then re-copy back over to the Canvas app, not sure?

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!

@rdorman , ( edited … Oups sorry, you refer to Teams ! My bad …)

Please check the Format property of the datepicker control to be set to “dd/mm/yyyy”.

Hope IT helps !

Was this reply helpful? Yes No
CU16050836-1 116 on at

Like (0)

Report
Copy link

Link copied!

Unfortunately the classic control has the same date picker interface as standard Power Apps, which my client hates (too big and requires user to click OK).

Was this reply helpful? Yes No
CU16050836-1 116 on at

Like (0)

Report
Copy link

Link copied!

There is no Format attribute for the date picker control. That was the first thing I looked for.

Was this reply helpful? Yes No
Verified answer

EddieE 4,641 Moderator on at

Like (1)

Report
Copy link

Link copied!

@rdorman
Then I think your only option here is to build your own. @mdevaney has a Blog article on how you could do this here. Plus there are plenty of YouTube videos on this subject.

I recently used Matt's article to build a Side by Side Date Picker like this, with a few extra bells and whistle:

Was this reply helpful? Yes No