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...
I keep seeing 'change regional settings' as a solution to this ongoing problem but it does not work. SharePoint date in SharePoint list remains in US format unless you switch to friendly view. The only way I have been able to work around it is to create a new calculated column that uses the date column in the US format and calculates it via a formula into a DD/MM/YYYY. I hide the incorrect column and display calculated column. This is not optimal because you cant modify the calculated column within the list (read only).
Would love to know how to resolve the date format issue (based in Australia).
Ditto! And it still does not work. I'm frustrated as heck, been stuck with this for 2 ish hours now.
Hello Jared,
This worked for me, so worth a shot:
https://techcommunity.microsoft.com/discussions/sharepoint_general/date-format-needs-to-be-ddmmyyyy/3070056/replies/3713272You need to go to site settings then in the Site Administration section select Regional Settings. Then change the Locale to a place that uses DD/MM/YYYY like the UK. I've never had a problem with it in 15 years.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)Rob - change worked for me in that it converted the existing dates but when I use the pull down calendar to enter the date it still enters it in the MM/DD/YYYY format and then flags a format issue. I can type it in manually but just wondered if I had missed a step. Thanks
