Date format needs to be DD/MM/YYYY

Contributor

Hi

When you create a new date column in SharePoint, the default format is MM/DD/YYYY.

 

However, I live in a country where we use DD/MM/YYYY, and changing in the default format into that is not approved by SharePoint - look at the screendump.

SharePoint_date_format.png

5 Replies
Hello!
that's controlled by your site's regional settings in settings,

https://tenant.sharepoint.com/sites/SITE_NAME/_layouts/15/settings.aspx

Change the locale to match your country. Let me know how it goes
THANKS! :)
This is perfect, thank you!

@microsoft please give a global option for this that can set default regional settings. Better Still set default based on tenant location ie uk datacentres default to uk settings. Changing per site is a pain and prone to admins forgetting to do this. TY

@Sean_Palmariellodivine - Absolutely!  It drives me crazy that when users create a list in Sharepoint (or rather in Teams) I have to go into the site settings to change the locale - when I've asked for my data to be in UK datacenters.

 

If not possible to default based on data location, there should absolutely be a "for all sites in this tenant that are or ever will be, here's the locale to use".