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

Revolutionize Your Business With Generative AI

From product design and software development to virtual agents, content creation, and reporting, GenAI is transforming business. Our AI experts help you unlock GenAI’s full potential and drive growth.

Let’s Get Started

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.