I did the following:-
- I have added an announcement list APP.
- Create a new date & time calculated column (named Announcement Date) with the following formula”
=TEXT(Date,"dd Mmm, yyyy")”
- Then on the AllItems views , I mention to filter based on the Date field Descending.
But I decide to hide the Date field and view the announcement date field only, in the AllItems view as follow:-
Currently the sort is working well, but if I decide to manually do the sort . by select Descending form the calculated field drop down then the sort will be wrong , and it will be based on the Day and not the date , so for example 29 January 1999 will be grater than 1 december 2013 !!. Although sorting based on announcement date descending should be the same as doing the sort based on the Date descending.
Can anyone advice what is causing this strange behavior !! Thanks.