How to sort a TEXT Date Column in sharepoint ?

Question

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!!

Answer 1

I'm not familiar with Sharepoint but this looks like a pure Excel question. I presume you don't really want to convert the date into text. Let it be a date and just change the cell format.