A mess with sorting a connected date column

I have a table to manage my domains.
One column is connected to a task table, to show the domain renewal task.
Another column shows the renewal task due date.

See what happens when I sort the domain table by the connected date column…


Dear @Ronen_Mayer

Trying to give you the right direction from my mobile device :handshake:
Visual Position of the row in table

By the looks of it, your formula returns a list of dates (even though it only contains a single date). Try adding .First() at the end and it should work.

See this

And this