SharePoint Online Site Date Format

In this SharePoint Online tutorial, I will explain all about the SharePoint Online date format. Then, I will show you the default date format in SharePoint Online. Then, we will discuss how to change the SharePoint Online site date format. In the last, I will show you, how to change the SharePoint date format by using JSON.

When you create a new date column in SharePoint Online, by default date format is MM/DD/YYYY. And, you can also change the date format from SharePoint regional settings.

Suppose I have a SharePoint Online list as “Employee Onboarding” and inside this, I have added a Date and Time column as shown below.

Table of Contents

How to change the date format in SharePoint Online

Here, we will discuss how to change the date format in SharePoint Online. To achieve this, follow the below steps. Such as:

Open the SharePoint Online site, where you want to change the date format, and click on the Gear icon and Settings. Then, select the Site information option under the SharePoint section like below.

Then, select View all site settings under the Site Information window.

how to change date format in sharepoint list to dd/mm/yyyy

Now, select Regional settings under the Site Administration section as shown below.

How to change date format in SharePoint Online

Here, in the Regional settings window, we will get all information such as:
- Time Zone: We can specify the standard time zone by a list of time zones.
- Region: You can select a locale from the list to specify the way the site displays numbers, dates, and times.
- Sort Order: We can also specify the sort order as per the requirement.
- Set your calendar: If you want to specify the type of calendar then, select your calendar.

For example, if you want to select the local date format, you will specify how the site displays the date format and click on the Ok button.

Once the date format is changed, it will appear like below.

DD-MM-YYYY

sharepoint list change date format to dd/mm/yyyy

This is how to change a date format in SharePoint Online.

SharePoint Online Date Friendly Format

If you want to display the date in a friendly format, follow the steps below.

Open the SharePoint list where you want to set the friendly format in the Date and time column. Then, click or expand the date column (Employee Onboarding) and select the Column settings. Then, click on the Edit option.

Then, enable the Friendly format slider (Yes) under the Edit column window. Then, click on the Save button.

SharePoint Online Site Date Friendly Format

Now, you can see the date format that how it will appear under the Date and time column.

Friendly date format in SharePoint Online

This is how to change the SharePoint Online date to a friendly format.

Change the SharePoint date format by using JSON

Now, I will show you, how to change the SharePoint date format by using JSON. Follow the below steps.

Open the SharePoint Online list, click or expand the date column and select the Column settings. Then, click on the Format this column option.

Then, click on the Advanced mode under the Format Onboarding Date column window like below.

Change the SharePoint Online date format by using JSON

Now, remove the default custom formatting from the box and change the display of this column by adding the JSON code below.


{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "children": [
    {
      "elmType": "div",
      "txtContent": "=toLocaleDateString(@currentField)"
    },
    {
      "elmType": "div",
      "style": {
        "padding": "0 2px"
      }
    }
  ]
}

Then, click on the Save button.

Once you added the JSON code, it will change the date format as shown below.

json date format dd/mm/yyyy sharepoint list

This is how to change the SharePoint Online date format by using JSON.

Conclusion

Here, I have explained all about the SharePoint Online date format. Step by step, we saw here, the default date format in SharePoint Online. Then, I explained how to change the SharePoint Online site date format. In the last, we covered how to change the SharePoint date format by using JSON.