How to change the date format for the new Microsoft Lists

Question

Hello Community, 

I want to be able to change the default date format (away from the US mm/dd/yyyy format to UK format dd/mm/yyyy for the new Microsoft Lists Office 365 app. All of the rest of our Office 365 apps are working properly and following the default user data format setup through the My Office Profile. Has anyone got any ideas, I would like to avoid hacking the page with some calculated field and instead inherit the proper user setting from the Office tenant if possible.

Cheers,

PM

Answer 1

Hi Paul.A.Miller,

Thank you for your post and requirement.

As the data for Microsoft lists is stored in OneDrive. So, the date setting in Microsoft lists app inherits from the OneDrive for business site via go to click on OneDrive settings> More settings>under Regional settings. See image below for your reference: 

I appreciate your patience and understanding.

Best Regards

Waqas Muhammad

Answer 2

Hi Paul.A.Miller,

I apologize for all the trouble it has caused and sorry about your time.

As per your description, if you want to set UK format date in SharePoint list you can create a calculated column  (for example: Date Created) based on the default Created column by using the formula as follows and then hide the Created column in SharePoint Online to see the result.

=TEXT(Created,"DD/MM/YYYY")

 

I appreciate your patience and understanding.

Best Regards

Waqas Muhammad

Answer 3

Thanks Waqas. While this is a workaround it seems a pretty ridiculous thing to have to do for a pretty core piece of functionality for a new app. Why on earth would the Microsoft app developers not look to inherit data settings from the Office 365 user defaults?

Answer 4

Thanks Waqas that solves it.

Answer 5

Hi Paul.A.Miller,

You are always welcome here. Thanks for your valuable feedback, glad to know that my replies helped you. Comments and feedback from our customers really motivate us to perform better and better and provided as much help as possible. We appreciate your kind words.

If there is any issue related with the Office applications in the future, please feel free to post back in this community.

We will be here for help.

Have a good day and stay safe 😊

Best Regards,

Waqas Muhammad