Custom sort date column which also includes text
Custom sort date column which also includes text
![fredmalone](https://secure.gravatar.com/avatar/6ba576f4da9de1e53edb3fee19257bf1/?default=https%3A%2F%2Fvanillicon.com%2F6ba576f4da9de1e53edb3fee19257bf1_200.png&rating=g&size=120)
I have a column in my financial data table that primarily shows a date value. However, in some instances it may be necessary to show the word MEMO in that column instead of a date.
Is it possible to sort this column and treat the word MEMO as a far future date, which is in essence what it is?
Example:
(ascending)
10/10/2017
11/01/2017
MEMO
MEMO
(descending)
MEMO
MEMO
11/01/2017
10/10/2017
Thanks!
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
Here is something using the ultimate date time plugin:
https://datatables.net/forums/discussion/49621
https://datatables.net/forums/discussion/comment/132341#Comment_132341
Thanks for pointing me to those posts. I searched before asking but apparently didn't search good enough.
Those help me get to where I need to be.