Sorting and displaying date column

[Benjamin]

Hi,

Currently i have a column in my radGrid which is a date. i am displaying this data now as string.

my requirement is as follows

1. this column has the possibility of null value. when the value is null to display data as -
2. the data should be formatted as dd MMM yyyy
3. when clicking on the header the data should be sorted as date.

So currently since my column is in string when i click on the header it is sorting the data as string i.e the data will be sorted as follows

(for descending)

27 Jan 2017 
23 Mar 2017
21 Jul 2017
19 Jan 2017 

 

it is suppose to be sorted as

21 Jul 2017

23 Mar 2017

27 Jan 2017 

19 Jan 2017