Sorting multiple Databases chronologically in one view

Get Help
1

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.

image
image1013×452 35.5 KB

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?

2

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

3

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