Hi, I have data :- 31-May-07 Its in a calculated column of the list. The method I used to get it :- =IF(FDate="","",TEXT(FDate,"dd-mmm-yy")) {FDate is a DateTime type of column. The returned value is stored in a "Single Line of Text" column type.} I am now unable to sort that column as its Text now and sorting is done on basis of strings. I need to sort this column on basis of Date. Any help ? Thanks!!

Hi, I can reproduce your issue, this is by design. Even though I create calculated column with date type, it also can’t be sorted by date. Hope this helps Thanks! StanffordEverything will be fine.