Dates Displayed in US format rather than UK

(1) Share

Report

Posted on 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 Pro Dev & ISV

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

narayan225 2,547 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
caharland 82 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

caharland 82 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
narayan225 2,547 Moderator on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No