column sorting

Posted by: mikematthee on 8 September 2017, 2:04 pm EST

  • Posted 8 September 2017, 2:04 pm EST

    Hi


    I am trying to sort a column containing dates correctly. The cells in the column are a combination of Comboboxcelltype and textcelltype. The date format is dd mmm yyyy. Does anyone know how I can correctly apply a filter based on dates rather than text on this column?


     Thank you for your help


    MikeMatthee

  • Replied 8 September 2017, 2:04 pm EST

    Mike,

    It seems you have combo box cell type which contains dates and wants to sort them as date type and not as string. If this is the case, then please have a look at this earlier thread.

    Thanks

  • Replied 8 September 2017, 2:04 pm EST

    That has worked for the date column but now I get an error when filtering a numeric column because its not a date. How can I implement this code so that it can only apply for a date column?
  • Replied 8 September 2017, 2:04 pm EST

    MIke,

    Using the CellType or GetType you can check if the required column is numeric cell type or Datetime and then apply the same logic as explined in the earlier provided thread. 

    Thanks

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels