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).
