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 this, I also picked the option so that this column is type date. The problem is that if I sort by "newest to oldest", for some reason May dissapears and it only starts at 30/04, then jumps to 30/03, 29/04, 29/03 and so on. It just sorts by day, not really the whole date. 

This would all be resolved if I can just show the date column in the right format.... But dunno if I can acheive this, as I think I need admin rights in order to change this. My sharepoint site is even in a different timezone than mine (like 8 hours behind). I do not understand why, if I go to the setting of my account they are clearly set to my country settings...

So the two questions:

1- how to sort the dates correctly (if I sort the original date it does it correctly)

2- how to change date format

  • 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's avatar
    Rob_Elliott
    Bronze Contributor

    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's avatar
      Rickytruco
      Brass Contributor
      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!!!!!

Resources