SharePoint Document Issues

Format SharePoint Date Columns for Specific Time Zones Using JSON

Rana GarciaRana Garcia Nov 4, 2026 869 views

Question details

The user needs to display date and time values in a specific time zone using JSON column formatting in a SharePoint list.

How to Format SharePoint Date Columns for a Specific Time Zone with JSON
Product
SharePoint Online
Device & OS
not provided
Scenario
Customizing the display format of date and time values within a SharePoint list or document library to reflect a designated local time.
Observed behavior
SharePoint's JSON formatting does not natively provide direct time zone conversion functions like JavaScript's toLocaleString method, requiring platform-specific settings to resolve.
Before you start

Ensure you have 'Design' or 'Full Control' permissions on your SharePoint site to apply column formatting and modify site regional settings.

Solution 1Recommended

Modify Site Regional Settings for Default Time Zone Adjustment

Since JSON formatting cannot dynamically convert time zones, adjusting the site's overall regional settings is the most reliable way to display the correct local time.

SharePoint internally stores all date and time values in Coordinated Universal Time (UTC). By default, it displays these values based on the site's Regional Settings rather than through column-level JSON formatting.

Adjusting the site-wide regional settings ensures all users see dates and times properly aligned with the required primary time zone.

1
Access Site Settings

Click the gear icon (Settings) in the top right corner of your SharePoint site, select 'Site information', and then click 'View all site settings'.

2
Open Regional Settings

Under the 'Site Administration' category, click on 'Regional settings'.

3
Select the Target Time Zone

Locate the 'Time Zone' dropdown menu, choose your desired specific time zone, and click 'OK' at the bottom of the page to save the changes.

Modify Site Regional Settings for Default Time Zone Adjustment
Free Microsoft Office alternative

Manage Complex Data Easily with WPS Office

If you frequently work with complex data sets, dates, and time zones, a dedicated spreadsheet tool is often more efficient than customizing web-based lists. WPS Office provides a lightweight, comprehensive, and highly compatible alternative to Microsoft Office, allowing you to manipulate and format data effortlessly.

Highly compatible with Microsoft Excel (.xlsx) formats and functionsRobust built-in tools for calculating dates and converting time zonesFree and lightweight with a familiar, easy-to-use interfaceSeamless offline document and spreadsheet management
QA img-9

Frequently Asked Questions

Can I use JavaScript functions like toLocaleString in SharePoint JSON formatting?

No, SharePoint column JSON formatting does not support custom JavaScript functions like toLocaleString. It relies on a limited set of native JSON operators and inherits time zones strictly from the site or user settings.

Why is my SharePoint date column showing the wrong time zone?

Dates in SharePoint are stored in UTC format. If the displayed time is incorrect, either the site's Regional Settings or your personal Office 365 profile time zone settings are misconfigured.

Where can I find supported JSON operators for SharePoint date columns?

Supported JSON properties and operators can be found in the official Microsoft SharePoint documentation under the section 'Use column formatting to customize SharePoint'.