Sort based on year, month and date in Table

[chibi]

I have several dimensions in the table, but I need help to sort out my dates accordingly. The date is not following the right sort. I removed all filters for sorting for the other dimensions and I even tried to sort based on expression but it's not working. Can someone help me please

[chaorenzhu]

Can you try apply Date() to your Date field? It should be in dual value with both the text value shown and numerical value used for sorting

[chibi · Accepted solution]

I got the formatting by sorting the date at the top and by removing the default sort for the other dimensions. Thank you @chaorenzhu