Monday, November 17, 2014

Change Regional Settings - Time Zone, Locale in SharePoint 2013 with PowerShell

Regional settings in SharePoint 2013 controls how locale-specific information, such as Date, Time, Numbers, calendar, etc. are displayed on the site. Internally, SharePoint keeps date time values in UTC format in database and presents to the end-user based on the configured regional settings.

SharePoint 2013 regional settings are configured in these levels:

  • Web Application Level
  • Site Collection Level
  • Site Level
  • User Level 
Web Application Level
Under web application general settings, we've "Default Time Zone" settings, which sets default regional settings for site collections at the time of its creation. 
  • Go to Central Administration Site
  • Manage Web Applications >> Select your web application
  • Click on "General Settings" ribbon button
Now, from the general settings page, you can set "Default Time Zone" for site collection.

SharePoint 2013 default regional settings
However, This setting has only "Time zone" configuration and sets the default Time zone for any new SharePoint site collections. (No effect on existing site collections under the specific web application). Of course, there are other regional settings like, "locale". I don't see any other ways to set default regional settings like "Locale" on new sites other than Feature stapling/custom site definitions.
sharepoint 2013 default regional settings
If nothing is specified in Web application's timezone settings, then your SharePoint Server's timezone will be used as regional settings for your site collections!

Reset web application's default time zone, use this script (Not possible through UI)
#Get Web Application
$webApp = Get-SPWebApplication "" 
#$Reset Web Application's default timezone

Site Collection Level and Site Level Regional Settings
Each site can have its own regional settings. When you create new sub-site, it inherits its parent sites's (not site collection!) regional settings by default. To change timezone in SharePoint 2013 sites,
  • Go to Site Actions Gear >> Site Settings 
  • Click on "Regional Settings" link under Site Administration
  • Now, you can set SharePoint 2013 site collection time zone
sharepoint 2013 set regional settings
 Of course, you can set other regional settings for SharePoint site, such as Locale, Sort order, Time format, etc. from regional settings page.

sharepoint 2013 timezone settings

User Level Regional Settings in SharePoint 2013:
Users can have their own regional settings rather than the one specified at site level. This is extremely helpful when users work between multiple timezones. To configure your personal regional settings,
  • Click on Welcome menu (Personal menu) >> My Settings
  • Click on "My Language And Region" link. 
  • Uncheck "Always follow web settings" and then specify your custom time zone and other regional settings.
sharepoint 2013 regional settings for user
Regional settings for user takes precedence on any other regional settings in SharePoint 2013.

PowerShell script to change site regional settings in SharePoint 2013
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

#Site URL variable
$SiteUrl =""

#Get site object
$web = Get-SPWeb $siteUrl

#Set Locale setting

#Set Timezone
$TimezoneID = 23 #(GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi
$web.RegionalSettings.TimeZone.ID = $TimezoneID

#$web.RegionalSettings.FirstDayOfWeek=1 #Sunday

#Update settings

Change User's Regional Settings using PowerShell:
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

#Get the Web
$Web = Get-SPWeb $WebURL
#Get the User
$User = Get-SPUser "i:0#.w|Crescent\salaudeen" -web $WebURL

#Configure User's Timezone settings
$UserTimeZoneId = 23 
$RegionalSettings = new-object Microsoft.SharePoint.SPRegionalSettings($web, $true)
$RegionalSettings.TimeZone.Id = $UserTimeZoneId

$User.RegionalSettings = $RegionalSettings
Refer this MDSN link to get IDs for timezone:

SharePoint 2013 central admin regional settings
SharePoint 2013 central administration regional settings are hidden. Just append: /_layouts/15/regionalsetng.aspx to the central admin URL to get regional settings of central admin. E.g. http://sharepointserver:2013/_layouts/regionalsetng.aspx

You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.

Check out these SharePoint products:


  1. How to add custom locale in SharePoint 2013. I need to change the date format for existing locale. Ex.

    Country Language Language Code Date Format Now Date Format Wanted
    Austria German de-AT DD.MM.YYYY DD/MM/YYYY

    1. If you don't want to change the language/locale to some other, which gives your desired date format, you are left with options such as : using calculated fields (TEXT(Created, "DD/MM/YYYY")), changing date format in data view XSL.

  2. My popularity trends are showing incorrect date/time its like 1 day behind (my assumption is in GMT or UTC). I checked the Regional Settings of our site and it is set correctly UTC+10:00 Canberra, Melbourne, Sydney And also checked the user regional settings, central admin and they are set correctly as well. Is there a way to correct this or we have to live with this :(


Please Login and comment to get your questions answered!

You might also like:

Related Posts Plugin for WordPress, Blogger...