Is there a way to sort date type columns by default?

Summary:

Is there a way to sort date type columns by default?
We want to sort this column with the DD/MM/YY format but by default we can only sort it by MM/DD/YY, if we do it by SQL query (TO_CHAR(date,'DD/MM/YY') and display the DD/MM/YY format, when sorting it would do so by alphanumeric level and not by date, for example, 01/07/2023 being less than 30/07/2023.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

24D

Code Snippet (add any code snippets that support your topic, if applicable):