Dates Displayed in US format rather than UK

Like (1) Share

Report

Posted on 2 Sep 2024 17:22:15 by caharland

Hi All,

I am based in the UK; however, my Dataverse date columns are being displayed in US format even though I have changed the environment date format to UK.

This is the table display screen:

This is the system settings format screen :

I get the same issue when displaying date columns in my Power App using the modern Table control (where you can't change the date format) ..

I'm hoping this is an easy fix?

Thanks for your consideration, Craig

Categories:

Power Apps component framework

All responses (4)

Answers (0)

narayan225 2,507 Super User 2025 Season 1 on 04 Sep 2024 at 07:35:42

Like (0)

Report

Dates Displayed in US format rather than UK

Hi Craig,

Because the columns of the modern table do not support formatting, you are not able to do this.

I believe you have found a workaround for this already.

Best of luck!
Suggested answer

caharland 73 on 03 Sep 2024 at 08:59:51

Like (0)

Report

Dates Displayed in US format rather than UK

Hi All,

Whilst this is not a direct solution; I have found a workaround by using the ADDCOLUMNS function to add correctly formatted columns the Table that is the data source for the table control. I use this function in the Items property of the table control as shown below.

After adding this code snippet, the columns Arrive Formatted and Depart formatted are available for selection and display in the modern table control, as shown below:

Cheers, Craig
caharland 73 on 03 Sep 2024 at 08:57:07

Like (0)

Report

Dates Displayed in US format rather than UK

Hi Narayan,

Thanks for your reply, However, as I'm just talking about the standard modern Table Control field display and not a data picker control; I'm not sure how this helps me?

Thanks, Craig
Suggested answer

narayan225 2,507 Super User 2025 Season 1 on 03 Sep 2024 at 02:31:21

Like (0)

Report

Dates Displayed in US format rather than UK

For model driven apps, you will need to set it from System Administration setting.

For canvas app, you can change the format of the date picker control.

Reference for canvas app: https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/controls/control-date-picker#key-properties

Check the format section.