Sort column data within depending upon data type
Sort column data within depending upon data type

Hi, I have a column with data of different data-types like below
29-07-2017
20-09-2018
The message
error
Test
I want to sort column first on the basis of date and then on text, for-example:
On asc order, the values should be
29-07-2017
20-09-2018
error
Test
The message
On desc order, the values should be:
20-09-2018
29-07-2017
The message
Test
error
Is there any way to do this?
This discussion has been closed.