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.
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 " http://sharepoint.crescent.com" #$Reset Web Application's default timezone $webApp.DefaultTimeZone=-1 $webApp.Update()
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
In Regional Settings page, following properties can be set:
- Time Zone: Time zone to use in date and time for activities, time stamps such as “Created On”, “Modified On”, etc
- Locale: Specify the locale to determine how numbers and dates are displayed.
- Sort Order: Identify sorting preferences to be used within the site.
- Set Your Calendar: Set the calendar format for the site and whether week numbering is displayed in the date navigator.
- Enable an Alternate Calendar: Specify a secondary calendar format to make this alternate information available in the site (If required).
- 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.
- Time Format: Specify whether the time format to be displayed as 12 or 24-hour.
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.
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 ="http://intranet.crescent.com" #Get site object $web = Get-SPWeb $siteUrl #Set Locale setting $culture=[System.Globalization.CultureInfo]::CreateSpecificCulture("en-US") $web.Locale=$culture #Set Timezone $TimezoneID = 23 #(GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi $web.RegionalSettings.TimeZone.ID = $TimezoneID #$web.RegionalSettings.Time24=$True #$web.RegionalSettings.FirstDayOfWeek=1 #Sunday #Update settings $web.Update()
Change User’s Regional Settings using PowerShell:
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue $WebURL="http://intranet.crescent.com" #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 $User.Update()
Refer this MDSN link to get IDs for timezone: https://msdn.microsoft.com/en-us/library/office/jj247008.aspx?f=255&MSPPError=-2147217396
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