Change Date Format in SharePoint [Modify in a Minute]

SharePoint doesn’t store “date format” as a simple setting. It stores actual date/time values, then decides how to display them based on the list column type, formatting rules, and regional/language settings.

If your dates show up as MM/DD/YYYY when you need DD/MM/YYYY, or if you want a consistent YYYY-MM-DD output, you can fix most cases in a minute—usually by changing column formatting or the view.

#	Preview	Product	Price
1		SharePoint For Dummies	$15.29	Buy on Amazon
2		Microsoft SharePoint: The Most Complete and Updated Guide to Store, Organize, Share, and Access...	$17.97	Buy on Amazon
3		SharePoint For Dummies (For Dummies (Computer/Tech))	$22.82	Buy on Amazon
4		Microsoft 365 and SharePoint Online Cookbook: A complete guide to Microsoft Office 365 apps...	$31.99	Buy on Amazon
5		Microsoft SharePoint Cheat Sheet – 2 Page Quick Reference Guide | Lists, Libraries, Document...	$12.99	Buy on Amazon

As an Amazon Associate I earn from qualifying purchases.

This guide focuses on the fastest, most reliable options for SharePoint Online and common on-prem setups.

Why SharePoint Date Formats Behave the Way They Do

A SharePoint date column is a data type (often “Date and Time”), not plain text. The same underlying value can render differently depending on user locale and the formatting layer you apply.

#1 Best Overall

Sale

SharePoint For Dummies

$15.29

Buy on Amazon

That’s why you may see one format in the list view, a different format in calendar views, and yet another format when exporting to Excel or CSV.

Prerequisites and What You Can (and Can’t) Change

• You can change display: list/table views, modern list column formatting, and calculated display fields.
• You can’t change storage: SharePoint will keep date/time values as values. Any “formatted date” you create as text is a separate field.
• You may need permissions: editing column settings or applying column formatting typically requires Manage Lists (or higher).
• Regional settings matter: some display behavior follows site/user locale even when the column itself is formatted.

Change Date Format for a List or Library Column (Modern Experience)

For most modern SharePoint lists and document libraries, the most direct way to control what users see is Column formatting. This works best when you need a consistent pattern like YYYY-MM-DD.

Use Column Formatting (Recommended)

Open the list, then apply formatting to the date column so it renders exactly how you want.

1. Go to your SharePoint List (or Document Library).
2. In the top-right, click Settings (gear icon) → List settings (or Library settings).
3. Find your date column under Columns.
4. Click the column name. If you don’t see formatting options here, use the modern list UI instead: open the list → hover the column header → click the Column settings menu (▼) → select Format this column.
5. Choose Format type as JSON.
6. Paste a JSON template using moment (SharePoint uses moment.js formatting patterns in column formatting).
7. Click Save.

Examples (replace FieldName with your internal field name):

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "span", "txtContent": "=if(@currentField, moment(@currentField).format('YYYY-MM-DD'), '')"
}

After saving, verify by changing one item and confirming the new display format in the view.

Use View Settings (When You Only Need a Display Change)

If you don’t need a custom text format and you just want the UI to follow how your site renders dates, view settings can help—especially in older list configurations.

1. Open the list.
2. Click All items (or your current view name) → Edit the current view.
3. Look for formatting/display options tied to column rendering.
4. Adjust the view’s column list and confirm the date column shows using your preferred layout.
5. Click OK / Save.

If your view offers only limited control, use column formatting instead. It’s the closest thing to a “format in a minute” switch.

Change Date Format for a SharePoint Column (Classic Experience)

Classic SharePoint often behaves more rigidly, but you still have viable options—mainly based on regional settings and view rendering.

Rank #2

Sale

Microsoft SharePoint: The Most Complete and Updated Guide to Store, Organize, Share, and Access Information from Any Device

$17.97

Buy on Amazon

Adjust Regional/Regional Settings First

In many classic cases, the most noticeable display change comes from adjusting site regional settings. This is also the root cause when different users see different formats.

1. Go to your site.
2. Open Site settings.
3. Find Regional settings (or Language settings depending on your UI).
4. Set the Locale to the format you want (for example, English (United States) for MM/DD/YYYY, or English (United Kingdom) for DD/MM/YYYY).
5. Save.

Use Column Options and View Settings

Classic list views may not honor complex formatting the same way modern column formatting does. Start by ensuring the view is configured to display the date column the way you expect.

1. Open the list.
2. Click All Items → Modify View.
3. Confirm the date column is included and not replaced by a differently typed calculated field.
4. Save and refresh the page.

How Date Display Relates to Regional Settings (Tenant, Site, and User)

SharePoint date formats are influenced by multiple layers:

• User locale (browser language and SharePoint user profile settings) can affect date rendering.
• Site regional settings can change default display preferences.
• Column formatting can override display in modern experiences, but exports may still follow underlying data rules.

If only one group sees “wrong” dates, don’t start by editing JSON. First confirm user locale and region.

Common Scenarios and Exact Fixes

Here are the real-world cases you’ll hit most often, with concrete actions.

Want YYYY-MM-DD Instead of MM/DD/YYYY

Use modern column formatting and format with moment(@currentField).format('YYYY-MM-DD').

1. Open the list.
2. Hover the date column header → Column settings (▼) → Format this column.
3. Select JSON.
4. Paste:

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "span", "txtContent": "=if(@currentField, moment(@currentField).format('YYYY-MM-DD'), '')"
}

Save and confirm a sample item displays the new pattern.

Want Day/Month/Year Like 09/May/2026

Format using the moment.js token DD/MMM/YYYY (or DD MMM YYYY if you want a space).

Rank #3

Sale

SharePoint For Dummies (For Dummies (Computer/Tech))

$22.82

Buy on Amazon

1. Go to Format this column.
2. Use:

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "span", "txtContent": "=if(@currentField, moment(@currentField).format('DD/MMM/YYYY'), '')"
}

If you need the month as a full word (May), use DD MMM YYYY.

Dates Look Wrong Only for Some Users

This is usually locale-related. Different users can have different language/regional preferences.

1. Have one user confirm their locale in SharePoint (and confirm browser language).
2. Check site Regional settings.
3. If you must enforce a single format for everyone, keep column formatting enabled, then validate the UI across multiple accounts.

Calendar Views Still Show Old Format

Calendar views sometimes pull their rendering rules from view templates rather than the same JSON path as standard table views.

1. Check whether your calendar view uses the same date column.
2. Try updating the column formatting again (save and refresh).
3. Switch to a standard list view temporarily to confirm JSON works.
4. If calendar rendering still won’t match, create a Calculated column that outputs a stable text representation and display that in the calendar-related UI if supported.

When Column Formatting Isn’t Enough

Sometimes you need a stable “string” representation, like for exports, email bodies, or downstream integrations. In those cases, create a field that stores the formatted text you want.

Use Calculated Columns for Stable Formatting

Create a calculated column that converts the date into a string. This helps when UI formatting doesn’t apply to exports or external tools.

1. Open List settings.
2. Under Columns, create a New column.
3. Choose type Calculated (output type Single line of text).
4. Use a formula appropriate for your scenario (for example, month/day/year tokens).
5. Save, then display the calculated column in your views.

Exact formula capabilities depend on classic vs modern and the field types involved. If your calculated formula can’t format as desired, move to Power Automate or Power Apps.

Use Power Automate to Write a Formatted Date String

If you’re already automating workflows, write a text version alongside the original date.

1. Create a flow triggered on item creation or modification.
2. Read the original date field.
3. Use the formatDateTime expression to generate a string (for example, format to yyyy-MM-dd).
4. Update the item’s “Formatted Date (Text)” column with the generated string.

This approach guarantees that the exported value and notifications match what you intend.

Rank #4

Sale

Microsoft 365 and SharePoint Online Cookbook: A complete guide to Microsoft Office 365 apps including SharePoint, Power Platform, Copilot and more

$31.99

Buy on Amazon

Use Power Apps for UI-Level Date Display

If your issue is only in a custom app interface, you can format dates in Power Apps without changing SharePoint column rendering.

1. In your Power Apps screen, display the date field in a label.
2. Use the Power Apps date formatting function to render YYYY-MM-DD, DD/MM/YYYY, or a custom string.
3. Leave the SharePoint column unchanged to preserve sorting and data integrity.

This is especially useful when you need a UI that must be consistent across users.

SharePoint Admin Options (Tenant/Site Level)

If the goal is to fix date display broadly across many lists, address regional settings at the site or tenant level instead of editing each column.

Update Regional Settings and Language Pack Impacts

For SharePoint Online, verify that site language and locale align with your organization’s expected format. Different Microsoft 365 configurations can change defaults.

1. Go to the site.
2. Open Site settings.
3. Configure Regional settings to match your target locale.
4. Confirm by testing with two different user accounts.

Verify Site Collection Settings and User Profiles

On-prem farms and older SharePoint setups can also be impacted by site collection settings and user profile configuration. If dates are inconsistent across sites, check those baseline settings before editing JSON.

Troubleshooting Guide

Date Still Shows the Old Format

• Confirm you formatted the correct column (internal name mismatches are common).
• Hard refresh the page (Ctrl+F5) and re-open the list view.
• If the column is used in multiple views, confirm you’re not looking at a different view/template.
• Check user locale. Column formatting should override UI display, but some surfaces (like calendar) can differ.

Column Formatting JSON Errors

If your JSON fails, SharePoint may show the raw date or ignore the formatting.

1. Make sure JSON is valid and uses double quotes consistently.
2. Use the $schema line shown in working examples.
3. Switch from complex formatting blocks to the moment(@currentField).format(...) approach.
4. Save, then re-open the formatting panel to see if SharePoint corrected or rejected the JSON.

Exported Files (Excel/CSV) Don’t Match the UI

UI formatting doesn’t always control export formatting. Exports commonly represent dates as date values or use locale in the export pipeline.

• For consistent exports, export the formatted text calculated column (or Power Automate-written field).
• Alternatively, post-process in Excel using a stable format transformation.

Sorting Breaks After Formatting Changes

If you changed display by replacing the date with text, sorting can become alphabetical instead of chronological.

Best Value

Microsoft SharePoint Cheat Sheet – 2 Page Quick Reference Guide | Lists, Libraries, Document Management, Sites, Web Pages, Permissions, Office Integration & Navigation

$12.99

Buy on Amazon

• Keep the original date column for sorting and filtering.
• Use the formatted text only for display/export if needed.

Best Practices (So You Don’t Create Hidden Data Problems)

• Don’t overwrite the original date: use formatting or a separate calculated/text field.
• Test in multiple surfaces: list view, form view, gallery view, and calendar view if you use it.
• Document your formatting: write down your target pattern (for example, YYYY-MM-DD) so future edits don’t regress.
• Use text fields for exports: if output consistency matters, store formatted text as a separate column.

FAQ: Changing Date Format in SharePoint

Can I change SharePoint’s date format globally for every list?

You can influence defaults via regional/site settings, but the most consistent way is per-column formatting in modern lists or using formatted calculated fields where exports matter.

Will JSON column formatting affect mobile views?

Often it does for modern list rendering, but always test. Some surfaces (like calendar) can differ and may not honor the same JSON path.

Is there a simple setting to switch MM/DD/YYYY to DD/MM/YYYY?

Yes—via regional settings for the site and/or user locale. If you need a fixed format regardless of user locale, use column formatting.

Why do I see date offsets (time zone differences) after formatting?

Formatting shows the date/time value in the context of how SharePoint and the browser interpret time zones. If you only care about the date (not the time), consider ensuring you’re storing the correct time (often midnight) or using a calculated “date-only” representation.

What’s the fastest approach if I just need the list UI to look right?

Use modern column formatting on the date column with moment(@currentField).format('YYYY-MM-DD') (or your desired pattern).

Bottom Line

To change date format in SharePoint quickly, use column formatting in modern lists so the UI renders the exact pattern you want—like YYYY-MM-DD or DD/MM/YYYY. If you need consistent exports or downstream text, add a calculated/formatted text field.

When results vary by user, it’s almost always locale or regional settings. Fix those first, then lock the display with formatting when consistency matters.

Quick Recap

SaleBestseller No. 1

SharePoint For Dummies

$15.29

SaleBestseller No. 2

Microsoft SharePoint: The Most Complete and Updated Guide to Store, Organize, Share, and Access Information from Any Device

$17.97

SaleBestseller No. 3

SharePoint For Dummies (For Dummies (Computer/Tech))

$22.82

SaleBestseller No. 4

Microsoft 365 and SharePoint Online Cookbook: A complete guide to Microsoft Office 365 apps including SharePoint, Power Platform, Copilot and more

$31.99

Bestseller No. 5

Microsoft SharePoint Cheat Sheet – 2 Page Quick Reference Guide | Lists, Libraries, Document Management, Sites, Web Pages, Permissions, Office Integration & Navigation

$12.99

Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.