You will need to know the locale ID of the country you want to use. You can also use PowerShell scripts to change the date format in SharePoint Online in one site collection and for all sites in the tenant. Right after that, all you need to do is click the ok button at the bottom to save the changes.įor more information on the date formats per country, you can check here: Listing of countries with their preferred date formats. The option here that will allow you to change the display dates format is the locale.Ĭlick the dropdown and choose your country or the country with the format that you want to use: You will now see the different regional settings that you can change:

Look for it under the site administration group: Step 3: Change the date format The next step is to go to the regional settings of the site. The first step here is to access the SharePoint Online settings page.Ĭlick the view all site settings link: Step 2: Navigate to the regional settings Related: SharePoint Subsite vs Site: How They Differ From Each Other Step 1: Access SharePoint settings Though it may not be that relevant today, subsites created in a site collection where you changed the regional settings will inherit those settings. This will affect the following date fields in SharePoint lists: Understanding the date format and its potential limitations is the first step toward tailoring your SharePoint Online experience to better suit your needs and preferences.Īs you will see in the following section, changing this format is a straightforward process that can greatly enhance your productivity and ease of use within the platform.Ĭhanging the date format simply means changing the locale or country of your SharePoint site collection. Others might prefer a more verbose format, like mmm dd, yyyy (e.g., Jan 01, 2023), especially when dealing with a non-technical audience.

While it works for some, there are many who prefer or are more familiar with different date formats, such as DD/MM/YYYY, often used in many countries outside the United States. One common issue that users run into with SharePoint’s default date format is its lack of flexibility. However, depending on your location or your company’s preferences, this may not be the most intuitive or efficient way for you and your team to work with dates. The default date format in SharePoint Onlineīy default, SharePoint presents dates in the format mm/dd/yyyy (this is the US format).

Step 2: Navigate to the regional settings.

The default date format in SharePoint Online.

Change date setup on microsoft 365