Forum Discussion

jensjakobsen1966's avatar
jensjakobsen1966
Brass Contributor
Jan 24, 2022

Date format needs to be DD/MM/YYYY

Hi

When you create a new date column in SharePoint, the default format is MM/DD/YYYY.

 

However, I live in a country where we use DD/MM/YYYY, and changing in the default format into that is not approved by SharePoint - look at the screendump.

    • Colin1024's avatar
      Colin1024
      Copper Contributor

      AndresGorzelany 

      This is a frustratingly bizarre idea though. I have teams that span 3 continents, with at least three preferences for date formats. SharePoint (and everything else that has knowledge of it) should use the USER's own preferences for date format. That's it.

  • Jackie2020's avatar
    Jackie2020
    Copper Contributor

    I keep seeing 'change regional settings' as a solution to this ongoing problem but it does not work. SharePoint date in SharePoint list remains in US format unless you switch to friendly view. The only way I have been able to work around it is to create a new calculated column that uses the date column in the US format and calculates it via a formula into a DD/MM/YYYY. I hide the incorrect column and display calculated column. This is not optimal because you cant modify the calculated column within the list (read only).

    Would love to know how to resolve the date format issue (based in Australia).

     

     

  • Pernille-Eskebo please give a global option for this that can set default regional settings. Better Still set default based on tenant location ie uk datacentres default to uk settings. Changing per site is a pain and prone to admins forgetting to do this. TY

    • MattKirbySW's avatar
      MattKirbySW
      Copper Contributor

      Sean_Palmariellodivine - Absolutely!  It drives me crazy that when users create a list in Sharepoint (or rather in Teams) I have to go into the site settings to change the locale - when I've asked for my data to be in UK datacenters.

       

      If not possible to default based on data location, there should absolutely be a "for all sites in this tenant that are or ever will be, here's the locale to use".

Share

Resources