Mapping Between SharePoint Time Zones and IANA Time Zones

The time zones in Moment come from the IANA Time Zone Database. It is different with the time zones available in SharePoint. If you are planning on using moment.js to do time conversions between time zones, then you will need the mapping between IANA Time Zones and SharePoint time zones. The SharePoint time zones are based on UTC offsets. It has a unique ID for each time zone. The following is the mapping between the SharePoint Time Zone ID, SharePoint Time Zone name and IANA time zone.

The full mapping in an Excel sheet is available here:

https://raw.githubusercontent.com/pengzhao-perficient/blog/master/TimeZonesMapping/SharePointIANATimeZoneMappings.xlsx

To use the mapping in JavaScript code, I created three JSON objects contains the mapping.

SharePoint Time Zone to SharePoint Time Zone ID

SharePoint Time Zone ID to IANA Time Zone

Choosing a Global Software Development Partner to Accelerate Your Digital Strategy

To be successful and outpace the competition, you need a software development partner that excels in exactly the type of digital projects you are now faced with accelerating, and in the most cost effective and optimized way possible.

Get the Guide

SharePoint Time Zone ID to SharePoint Time Zone

Here are the examples for how to use it:

// Convert SharePoint Time Zone “(UTC-08:00) Pacific Time (US and Canada)” to its Time Zone ID

var id = SPTimeZoneNameToSPTimeZoneId[“(UTC-08:00) Pacific Time (US and Canada)”];

// Output: id is 13

// Get time zone ID (13) to its IANA Time zone name

var IANATimeZoneName = SPTimeZoneIdToIANATimeZoneName[“13“];

// Output: IANATimeZoneName is America/Los_Angeles

The complete mapping file is available here.

https://github.com/pengzhao-perficient/blog/blob/master/TimeZonesMapping/SPIANATimeZoneMappings.js

With the help of these mapping JSON objects, you are now able to use my favorite moment.js library to do the time zone conversions in SharePoint.

Please leave a comment if you find any invalid mapping.