Custom sort date column which also includes text

fredmalone

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!

rf1234

Here is something using the ultimate date time plugin:

https://datatables.net/forums/discussion/49621

https://datatables.net/forums/discussion/comment/132341#Comment_132341

fredmalone

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.