Format SharePoint Date Columns for Specific Time Zones Using JSON
Question details
The user needs to display date and time values in a specific time zone using JSON column formatting in a SharePoint list.

- 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.
Ensure you have 'Design' or 'Full Control' permissions on your SharePoint site to apply column formatting and modify site regional settings.
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.
Click the gear icon (Settings) in the top right corner of your SharePoint site, select 'Site information', and then click 'View all site settings'.
Under the 'Site Administration' category, click on 'Regional settings'.
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.

Apply Custom JSON Formatting for Visual Date Display
Use advanced JSON formatting to customize the visual layout of the date column, noting that it will inherit the site's defined time zone.
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.

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'.




