How to sort date and string in same column?
How to sort date and string in same column?
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??