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

​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  Read More

​