Sorting dates in 2 columns

[FaCe]

Hi,

i've 2 columns with dates in them.

I need to sort the dates showing the date in ascending order checking dates in both column.

i.e. in this sample i need to order date of both column so that i can see:

21.3.2023

then 

31.3.2023

then

2.4.2023

How to do that ?

[James_Burns]

Are you looking for something like this?

You could create a virtual column that finds the max date from both columns and then set the table to sort by that virtual column.

[FaCe]

my App can have dates in SCADENZA or in DA FARE or in both or not have date values in both

If in both columns there's a date value SCADENZA is always > of DA FARE

I'd like to show:

first order with date value in columns

If in both column there's a date value SCADENZA is always > of DA FARE

if i have date only in SCADENZA and only in DA FARE column:

SCADENZA

21.3.2023 (1 to show)

24.3.2023 (5 row to show)

27.3.2023 (7 row to show)

DA FARE

21.3.2023 (2 row to show)

22.3.2023 (3 row to show)

23.3.2023 (3 row to show)

25.3.2023 (6 row to show)

if in a row we have date in both columns than we order dates taking date value only from DA FARE column

at the end show rows that not have date in both columns

[Joseph_Seddik]

As @James_Burns suggested, have a virtual column, write whatever sorting rules you desire in its formula, then sort by this column.