Fix SharePoint List Date Difference Column Showing Incorrect Numbers
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.

- 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.
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.
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.
Navigate to the list settings by clicking the gear icon in the top right corner and selecting 'List settings'.
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.
Ensure your JSON code uses this exact internal name (e.g., '[$ReleaseDate]') and that the column is strictly configured as 'Date and Time'.

Isolate the Issue with a New Test List
Determine if the issue is a systemic JSON problem or isolated to corrupted list metadata by creating a fresh environment.
Escalate to Microsoft 365 Support
If the issue is isolated to a single list and persists across new columns within that list, administrative intervention is required.
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. Download the installer: Visit the official WPS Office website and download the free version for your specific operating system.
- 2. Install the suite: Run the installer and follow the on-screen prompts to set up WPS Office on your computer.
- 3. Open your files: Launch WPS Office and instantly open your existing Microsoft Office documents without format distortion.

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.




