SharePoint Online Site Date Format [With Examples]

In this SharePoint Online tutorial, we will learn about the SharePoint Online Site date format. Also, we will discuss more topics of SharePoint Online Date Format as listed below:

  • What is SharePoint Online Site Date Format
  • Working with SharePoint Change Date Format in List
  • How to change date format in SharePoint list to dd/mm/yyyy
  • SharePoint date column formatting json examples

Also, Read: SharePoint Online List Title Column [Detailed Guide]

SharePoint Online Site Date Format

In SharePoint Online Sites, by default, the dates are displayed in US format (MM/DD/YYYY). If we want, we can change the date format based on our requirements. But, first, we need to change the date format inside the SharePoint Regional settings.

SharePoint Change Date Format in List

In this section, we will see how to work with SharePoint Change Date Format in List.

  • For Example, we have taken a SharePoint Online List ‘Content Scheduler’. This list contains two date columns:
    • Draft due by
    • Publish by
  • Now we will change the date format of these two columns.
SharePoint json formatting
SharePoint json formatting
  • Click on the Settings icon (from the top right corner) -> Select Site information.
  • In the Site Information window, click on View all site settings.
Date format in SharePoint Online Site
Date format in SharePoint Online Site
  • On the Site Settings page, Click on the Regional settings under the Site Administration section.
Set SharePoint Online Site Date Format
Set SharePoint Online Site Date Format
  • Regional Settings window opens up with various options as listed below:
    • Time Zone: Here, we have to specify the standard time zone. When we expand the Time zone different options are shows up as shown below. For Example, we have selected (UTC) Coordinated Universal Time.
Set Date Format in SharePoint Online List
Set Date Format in SharePoint Online List
  • Here, we can what happens when we have changed Time zone
Date formatting in SharePoint Online List
Date formatting in SharePoint Online List
  • Region: Under region, many options are there such as Locale, Sort Order, Set Your Calendar, etc.
    • Locale: In locale by default English (Australia) is there. Here, we will select a locale from the list to specify the way the site displays numbers, dates, and times.
    • Sort Order: It will specify the sort order and get changed automatically when we change the locale. For Example, when we selected English(Australia) in the locale then, the Sort order changed automatically to General.
SharePoint Online List Date & Time Format
SharePoint Online List Date & Time Format
  • Here, we can observe the changes in the SharePoint Online Date column.
How to set date in SharePoint Online List
How to set date in SharePoint Online List
  • Enable An Alternate Calendar: We can select a secondary calendar that provides extra information on the calendar features. For Example, we have taken an alternate calendar as Gregorian Transliterated English Calendar.
  • Define Your Work Week: Here, we will set the work week, the first day of each work week, and also the working hours as per the requirements.
  • Time Format: Here, we can specify the time format whether to use 12 hours or 24-hour format.
  • Then, click on the OK button.
SharePoint Online Date & Time Format
SharePoint Online Date & Time Format

This is how we can Set the Date Format in SharePoint Online Site List.

Check out: How to Delete a Column in SharePoint Online List

How to change date format in SharePoint list to dd/mm/yyyy

Here, we will discuss how to change the date format to “DD/MM/YYYY”.

  • For Example, we have taken a SharePoint Online List Content Scheduler’s date column Draft due by to set the date format as shown below.
SharePoint date column formatting json examples
SharePoint date column formatting json examples
  • Click on the Settings icon -> Select Site information.
How to set the Date Format in SharePoint Online Site
How to set the Date Format in SharePoint Online Site
  • On the ‘Site Information’ page, Click on View all site settings.
Change Date Format in SharePoint Online List
Change Date Format in SharePoint Online List
  • Site Settings window opens up with various options such as Look and Feel, Web Designer Galleries, Site Actions, Site Administration, Site Collection Administration, Search, and Microsoft Search.
  • Under Site Administration -> Click on the Regional settings.
Set Date & Time Format in SharePoint Online List
Set Date & Time Format in SharePoint Online List
  • Regional Settings window opens up -> Under Region select locale to English(Indian).
  • Now, click on the OK button.
Date Formatting in SharePoint Online Site List
Date Formatting in SharePoint Online Site List
  • Now, we can see how our Date & Time column appears in the ‘DD/MM/YYYY’ format.
Change in Date & Time column in SharePoint Online
Change in Date & Time column in SharePoint Online

This is how we can change the date format to DD/MM/YYYY format.

SharePoint Online Date Friendly Format

Here, we will discuss SharePoint Online Date Friendly Format.

  • For Example, we have taken ‘Content Scheduler’. This list has a Date column named Publish by and Draft due by.
  • Now, expand the number column (Publish by) -> Click on Column settings -> Select Edit as shown below.
Friendly Format in SharePoint Online
Friendly Format in SharePoint Online
  • In this Edit column, go to the Friendly format and move the toggle towards Yes.
  • Click on the Save button.
SharePoint created date format
SharePoint created date format
  • Now, we can see the difference when we enable the date friendly format (Publish by) and without enabling date friendly format (Draft due by).
Format Date Column in SharePoint List
Format Date Column in SharePoint List
  • For Example,
    • Case I: The date will appear as shown below when we insert the current date in a SharePoint Online friendly date format.
SharePoint date display format friendly vs standard
SharePoint date display format friendly vs standard
  • Case II: The date will appear as shown below when we insert the date after 6 days from the current date in SharePoint Online friendly date format.
SharePoint change date format in the list
SharePoint change date format in the list

This is how we can enable the SharePoint Online Date Friendly Format.

SharePoint list format date json

Here, we will see how SharePoint Online list date column format using JSON.

  • For Example, we have taken ‘Content Scheduler’. This list has a Date column named Draft due by. Now we will change this date format by using JSON.
JSON examples in SharePoint date column formatting
JSON examples in SharePoint date column formatting
  • To do this, expand the number column (Draft due by) -> Click on Column settings -> Select Format this column as shown below.
SharePoint Date Column Format using JSON
SharePoint Date Column Format using JSON
  • In this, Format Draft due by column -> Select Advanced mode.
Using JSON Format Date Column in SharePoint Online List
Using JSON Format Date Column in SharePoint Online List
  • Now, it will redirect to Format Draft due by column where we can find some default JSON as shown below.
JSON Date Format DD/MM/YYYY SharePoint List
JSON Date Format DD/MM/YYYY SharePoint List
  • Instead of the JSON above, we have to write the JSON code to format the SharePoint Online Date Column as given 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"}},
      {"elmType": "div", "txtContent": "=toLocaleTimeString(@currentField)"}
    ]
}
  • Write the JSON to format the date in DD/MM/YYYY format in SharePoint Online.
  • Then, click on the Save button.
Date Column in SharePoint Online
Date Column in SharePoint Online
  • Now, we can see the changes in SharePoint Online List after adding the JSON.
JSON Conditional Formatting SharePoint
JSON Conditional Formatting SharePoint

This is how we can use JSON to format the date column in SharePoint Online.

Additionally, you may like some more SharePoint Online tutorials:

Conclusion

From this SharePoint Online tutorial, we have learned about the SharePoint Online Site date format. Also, we have learned more topics of SharePoint Online Date Format as listed below:

  • What is SharePoint Online Site Date Format
  • Working with SharePoint Change Date Format in List
  • How to change date format in SharePoint list to dd/mm/yyyy
  • SharePoint date column formatting json examples