SharePoint Lists displaying wrong date format

Question

SharePoint Lists displaying wrong date format

Anonymous

I have a problem where all of our SharePoint lists in our tenancy are displaying dates in the US date format despite being in a country that uses a different date format. This applies to all users and all sites in the tenancy.

I have checked the date format for my user account and the date format for the site. Other dates in the site (such as the last published date of the home page) are showing in the correct date format. When I go to edit the list value it shows in the correct date format in the edit window, however when displaying the List it shows the dates in the incorrect date format.

I am the site administrator and tenancy administrator; I have checked the regional settings for the SharePoint site, for my user account and for the tenancy.

[EDIT]

For anyone having a similar issue I have just found the solution myself.

Edit the column field for an affected list, select "Include Time", edit one row entry, make no changes and click OK, then edit the column field back to remove the "Include Time" setting. That specific list now displays the correct date setting. Repeat the process for each affected list.

Would be great if this wasn't a glitch that requires manual intervention after correcting regional settings, but I now at least have a way to solve the problem.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Answer 1

Dear Jarrod,

Good day!!

Glad to hear that you have resolved the problem you are facing and appreciate for sharing the solution, where it will help the other users in this community with the similar issue.

In addition, we will also report your issue to the internal team from our end.

At last, if you have any queries in the future, please feel free to open a new thread in this community and we will be here to assist you at our best.

Appreciate your patience and understanding. Have a great day!!

Best Regards,

Sophia

Answer 2

I am noticing that as of a few months ago our SharePoint sites are showing page published dates in US mm/dd/yyyy format despite the site settings being English (Australia) and dd/mm/yyyy

It's not a function of the browser viewing the page. In case Microsoft changed how it works I tried viewing the site using Chrome and Edge with dd/mm/yyyy settings and confirmed that my Microsoft 365 profile settings match.

It appears that Microsoft has hard coded US dates in even more places in SharePoint than was the case before. This is a big step backward for internationalisation.