How to sort date and string in same column?

How to sort date and string in same column?

amandeep_kauramandeep_kaur Posts: 1Questions: 1Answers: 0
edited August 2015 in Free community support

I have a table containing "Date(in format M/d like 'Aug-23')" and string(like 'process' and 'completed') in same column. But the issue is that it is sorted alphabetically not sort according to Date.
And structure of my file is:



<script type="text/javascript" language="javascript" class="init">
$(document).ready(function() {
$('#sorting').dataTable( {
"dom": '<"top"iflp<"clear">>rt<"bottom"iflp<"clear">>'
} );
} );
</script>

CPA Shipping
#123 Aug-28
#327 July-30
#789 Process

if i sort shipping column then it give result like

Process
Aug-28
July-30

But i want result like:
Process
July-30
Aug-28

means firstly string sorting and after that date sorting

And these shipping values are coming from Mysql database

How I solve this issue??
Any Suggestion??

This discussion has been closed.