Forum Discussion
Date format needs to be DD/MM/YYYY
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 ap...
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
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
This is a frustratingly bizarre idea though. I have teams that span 3 continents, with at least three preferences for date formats. SharePoint (and everything else that has knowledge of it) should use the USER's own preferences for date format. That's it.
it doesn't work to me AndresGorzelany
AndresGorzelany
Changing the site's regional settings appear to have no effect on the Modified column in our site's document lists.
Is there anywhere else we can change these settings?- Can you show the regional settings and column settings?
- I have the same problem, but I am trying to create a new column called "EventDate" and both the site and the hub site regional settings are all set to NZ, I can display the date correctly by using "Friendly" display format or JSON. But USER INPUT still uses US date format so staff are going to enter it wrong all the time! I have looked and looked but cannot find a solution???
- This is perfect, thank you!
- THANKS! 🙂
