SharePoint Document Issues

Fix Incorrect Date Display in SharePoint Date of Birth Field

Maira Mehtab Sep 21, 2026 868 views

Question details

The user needs to fix a SharePoint list Date of Birth field that displays an incorrect date in the modern experience, despite showing correctly in the classic experience and edit mode.

Product: SharePoint
Device & OS: not provided
Scenario: Viewing list entries in a SharePoint modern experience where a specific DD/MM/YYYY date format is required for a Melbourne (UTC+10) locale.
Observed behavior: The date displays incorrectly in the modern list view, while the edit view and classic experience correctly display the intended date.

Before you start

Ensure you have Site Owner or Administrator permissions to access and modify the regional settings for the affected SharePoint site.

Solution 1Recommended

Verify and Align Site Regional Settings

Use this solution to ensure the underlying site locale and timezone configurations accurately reflect your required UTC+10 and 24-hour formats.

SharePoint date discrepancies between classic and modern views are often caused by conflicting regional settings. The modern experience relies heavily on both site-level and user-level timezone configurations, which can shift dates by a day if misaligned.

Access Site Settings

Click the Gear icon in the top right corner of your SharePoint site, select 'Site Information', and then click 'View all site settings'.

Open Regional Settings

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

Confirm Locale and Time Zone

Verify that the Locale is set to English (Australia) for DD/MM/YYYY format, the Time Zone is set to UTC+10:00 (Melbourne), and the Time Format is set to 24-hour. Save any changes made.

Take a Screenshot: It is recommended to take a screenshot of your original settings before making changes, so you can revert back if necessary.

Solution 2

Inspect Column Formatting in Modern View

Check if custom JSON column formatting is altering how the date is rendered in the modern experience.

Solution 3

Standardize Personal Profile Time Zone

Ensure your personal Microsoft 365 account timezone matches the SharePoint site's timezone to prevent unintended date shifts.

Free Microsoft Office alternative

Manage Exported List Data with WPS Office

If you frequently export SharePoint lists to spreadsheets to manage dates and records, WPS Office provides a lightweight, free, and highly compatible alternative to Microsoft Office for editing your data offline.

1. Export List: In your SharePoint list, click the 'Export' button and select 'Export to Excel'.
2. Open in WPS Office: Launch WPS Spreadsheets and open the downloaded list file to view your data.
3. Format Dates: Select the Date of Birth column, right-click, choose 'Format Cells', and apply the DD/MM/YYYY date format locally.

Fully compatible with Microsoft Excel (.xlsx) formats and SharePoint data exports.Easily apply custom date formats like DD/MM/YYYY using familiar spreadsheet tools.Lightweight software with a highly intuitive, tabbed interface.Completely free alternative to traditional Microsoft Office subscriptions.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my SharePoint date show up as one day off?

This is typically caused by a mismatch between the SharePoint site's regional time zone settings and your personal account's time zone settings. SharePoint adjusts dates and times dynamically in the modern view based on the user's local timezone.

How do I force the DD/MM/YYYY date format in a SharePoint list?

To enforce the DD/MM/YYYY format, you need to navigate to Site Settings > Regional Settings and change the Locale to a region that uses this format by default, such as English (Australia) or English (UK).

Why does a date look correct in classic view but wrong in modern view?

The modern SharePoint experience processes date and time differently, relying heavily on user-specific regional settings and modern column formatting (JSON). The classic experience strictly relies on server-side site settings. Checking personal timezone settings usually resolves this discrepancy.

Document & File Issues