SharePoint List- Date field has changed to M/D/YYYY instead of DD/MM/YYYY

Question

Hi Team

Hope everyone had a good Xmas break.

We've recently upgraded to a new version of SharePoint and the date field has reverted back to M/D/YYYY where it should be DD/MM/YYYY.

I noticed the issue yesterday when I tried to paste data in date field while in grid mode which returned values of M/D/YYYY

The regional setting shows as Melbourne Australia - is there another step in the process I've missed

Regards

Harry

Answer 1

Hi @Harry N Nomikos ,

Based on your screenshot, I presume you are using SharePoint Server 2019. I tested in my environment, when I changed the regional settings to be the same as yours, I tested in my list, the date format has been changed to DD/MM/YYYY.

Given this situation, we would like to collect some information for further investigation:

1. Does it happen to a specific list only? Try creating a new one to verify.
2. You can also try it in a different site to see if the issue is related to that specific site.

3.Change the Time Format setting to 24 Hour, and then click OK. Then check it whether be changed.

And any other details will be grateful.

Regards,

Amy Jiang

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.