SharePoint Document Issues

Fix SharePoint List Date Difference Column Showing Incorrect Numbers

Chanuka GeekiyanageChanuka Geekiyanage Oct 29, 2026 868 views

Question details

The user needs to resolve an issue where a SharePoint list column using JSON formatting to calculate the days between a date and today displays a large, incorrect number in one specific list.

Fix SharePoint List Date Difference Column Showing Incorrect Numbers
Product
Microsoft SharePoint
Device & OS
not provided
Scenario
Applying custom JSON formatting to a SharePoint list column to calculate and display the number of days elapsed since a specific date.
Observed behavior
The column displays a large, unexpected number (e.g., 19004, 19005) that increments daily, indicating a raw date-serial conversion issue isolated to a single list.
Before you start

Ensure you have the exact JSON code being used for the calculation and verify your permission level allows you to create new test lists and modify column formatting on the SharePoint site.

Solution 1Recommended

Verify Column Internal Names and Data Types

Check that the JSON formatting references the exact internal name and correct data type of the date column.

SharePoint JSON formatting relies heavily on accurate column internal names. If the display name is used instead, or if the column is incorrectly configured as text rather than a Date/Time object, the JSON calculation will fail and may return raw serial values.

1
Check list settings

Navigate to the list settings by clicking the gear icon in the top right corner and selecting 'List settings'.

2
Find the internal name

Click on your specific Date column. Look at the URL in your browser to find the 'Field=' parameter at the end, which shows the true internal name.

3
Update JSON code

Ensure your JSON code uses this exact internal name (e.g., '[$ReleaseDate]') and that the column is strictly configured as 'Date and Time'.

Verify Column Internal Names and Data Types
Date Value Conversion: Large 5-digit numbers like 19004 often indicate the date is being parsed as an integer (the number of days since January 1, 1900) rather than a formatted date string.
Free Microsoft Office alternative

Experience Seamless Document Management with WPS Office

While Microsoft SharePoint handles complex list metadata and JSON formatting, many of your daily document collaboration and viewing tasks can be simplified. WPS Office provides a free, lightweight, and fully compatible alternative to Microsoft Office for your local and cloud document needs.

  1. 1. Download the installer: Visit the official WPS Office website and download the free version for your specific operating system.
  2. 2. Install the suite: Run the installer and follow the on-screen prompts to set up WPS Office on your computer.
  3. 3. Open your files: Launch WPS Office and instantly open your existing Microsoft Office documents without format distortion.
Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Free, lightweight, and incredibly fast to install and launch on any operating system.Familiar user interface with a tabbed workspace for easy document switching.Built-in PDF editing, merging, and format conversion tools at no extra cost.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my SharePoint date column show a 5-digit number like 19000?

In Microsoft systems, dates are often stored as serial numbers representing the total number of days since January 1, 1900. If your JSON formatting fails to properly parse the Date object, it may display this raw serial number instead of the correctly formatted difference.

How do I find the internal name of a SharePoint column for my JSON code?

Go to List Settings and click on the specific column name. Look at the URL in your web browser. At the very end of the URL, the text after 'Field=' is the exact internal name you must use in your custom JSON formatting.

How do I apply JSON formatting to a SharePoint list column?

Click the down arrow next to the column header in your SharePoint list, select 'Column settings', and then 'Format this column'. Click 'Advanced mode' at the bottom of the panel to paste your custom JSON code, and hit 'Save'.

What should I do if JSON formatting works in one list but not another?

This usually indicates an issue with the specific list's configuration, metadata corruption, or a mismatched column internal name. Try recreating the column from scratch. If the issue persists on that specific list only, your Microsoft 365 administrator may need to open a support ticket to resolve backend site errors.