Sort column data within depending upon data type

Sort column data within depending upon data type

anujeetanujeet Posts: 39Questions: 15Answers: 0

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.