Forum Discussion
Solved
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 ...
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)
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)
Rob_Elliott omggggggggggg this fixed it! And I have this issue going on soooo many different sites now they'll be fixed thanks so much :D!!!!!