Sorting and displaying date column

1 posts, 0 answers
  1. Benjamin
    Benjamin avatar
    62 posts
    Member since:
    Jul 2016

    Posted 01 Feb 2017 Link to this post

    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 

Back to Top