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 ap...
Lists
Jesse_Cooper's avatar
Jesse_Cooper
Copper Contributor
Jan 10, 2023

AndresGorzelany 
Changing the site's regional settings appear to have no effect on the Modified column in our site's document lists.
Is there anywhere else we can change these settings?

  • AndresGorzelany's avatar
    AndresGorzelany
    MVP
    Jan 10, 2023
    Can you show the regional settings and column settings?
    • CadiPNZ's avatar
      CadiPNZ
      Copper Contributor
      Jan 15, 2023
      I have the same problem, but I am trying to create a new column called "EventDate" and both the site and the hub site regional settings are all set to NZ, I can display the date correctly by using "Friendly" display format or JSON. But USER INPUT still uses US date format so staff are going to enter it wrong all the time! I have looked and looked but cannot find a solution???
      • CadiPNZ's avatar
        CadiPNZ
        Copper Contributor
        Jan 15, 2023
        Additionally, I know it comes up with a date picker, which is fine if the date you want to enter is recent but say you want to enter 01/05/1970... nobody is going to click it back month by month for 52 odd years! So they will type it in 01/05/1970 meaning 1st May 1970 but without knowing they are actually entering 5th January 1970 which is incorrect.

Resources