Sorting multiple Databases chronologically in one view

This is similar to Dates End for sorting (multiple databases)
I have one Agenda list view and I want to see entities sorted in chronological order. Two of these databases have a Date range called Dates that is an integration field. The other two have a date range called dates that is a formula field.


Unfortunately the Dates Start and Dates End values don’t show up as an allowed global sorting field.

Is there some other way to work this out?

Curious. What happens if you add the sort to each db individually?

They sort in order within each database and stack on top of each other in the order of the databases in the screenshot :frowning: