Change Regional Settings – Time Zone, Locale in SharePoint 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 

Change Regional Settings at the 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 a “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

As a global organization, you may want to change the regional settings such as the timezone of your site collection based on the team’s location, instead of the time zone set by the SharePoint server’s location.  Each site can have its own regional settings. When you create a new subsite, it inherits its parent site’s (not site collection!) regional settings by default. To change the 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

In Regional Settings page, following properties can be set:

  1. Time Zone: Time zone to use in date and time for activities, time stamps such as “Created On”, “Modified On”, etc
  2. Locale: Specify the locale to determine how numbers and dates are displayed.
  3. Sort Order: Identify sorting preferences to be used within the site.
  4. Set Your Calendar: Set the calendar format for the site and whether week numbering is displayed in the date navigator. 
  5. Enable an Alternate Calendar: Specify a secondary calendar format to make this alternate information available in the site (If required).
  6. Define Your Work Week: Specify the days of the workweek, the first day of the week, the first week of the year, and the start and ending time of the workday.
  7. Time Format: Specify whether the time format to be displayed as 12 or 24-hour.
sharepoint 2013 timezone settings

User Level Regional Settings in SharePoint 2013:

Users can have their own regional settings rather than the one specified at the site level. This is extremely helpful when users work between multiple time zones. 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

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

Salaudeen Rajack

Salaudeen Rajack is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

4 thoughts on “Change Regional Settings – Time Zone, Locale in SharePoint with PowerShell

  • February 27, 2018 at 1:05 PM

    Hi Salaudeen,

    How can we achieve this for all Users (Everyone) on SharePoint 2013 Foundation.

    Nitin Sali

  • March 23, 2016 at 11:03 PM

    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 🙁

  • December 28, 2015 at 6:55 AM

    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

    • December 28, 2015 at 12:44 PM

      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.


Leave a Reply