Custom sort date column which also includes text
Custom sort date column which also includes text

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.