The date format in my SharePoint 2010 Farm is set to the US format (mm-dd-yyyy). I need to make a global change so that the displayed date is in the format dd-mm-yyyy for all documents.

Can anyone suggest how I might achieve this?

I know that I can go into the Site Settings for each site and change the Regional Settings > Locale. But I need to make this change over the entire farm.


It is not possible to change it at farm level. Instead, you can create a calculated field for original date field and format the date accordingly.


Someone has posted a similar question before on here. They were given this bit of powershell to iterate through the Site Collections in the farm and change the settings to the UK region:

[Reflection.Assembly]::LoadWithPartialName("System.Globalization") | out-null
get-spweb -site http://yoururl -limit all |% {
    $_.Locale = [System.Globalization.CultureInfo]::GetCultureInfo(2057);
#see if things applied
get-spweb -site http://yoururl -limit all |% {

Could you use something like this? The original answer is here: Change locale for all site collections

  • Hi, is it possible to change the locale for all mysite hosts via Powershell? – Nigel Sep 18 '14 at 1:32
  • is it possible to change the date settings to dd-MMM-YYYY ? – userAZLogicApps Mar 27 '17 at 10:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.