Forum Discussion

Rickytruco's avatar
Rickytruco
Brass Contributor
May 03, 2024

Sharepoint calculated column problem (changes date format)

So I have a date column for my Sharepoint list that for some reason shows it as "mm/dd/yyyy": We don't use this format, we use (dd/mm/yyyy), so I created a calculated column that changes the date to ...
  • Rob_Elliott's avatar
    May 03, 2024

    Rickytruco it sounds like the regional settings for your site are not set properly. You don't need to be a global SharePoint admin to change this but do need to be an owner of the site. Go to the gear icon in the top right and select Site Information and then select View all site settings. Then in the Site Administration section select Regional settings.

     

     

    In the Regional Settings screen select your time zone and locale: 

     

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

Resources