# Sorting multiple Databases chronologically in one view **URL:** \ **Category:** Get Help\ **Created:** [June 11, 2025, 3:53pm UTC](https://community.fibery.io/t/sorting-multiple-databases-chronologically-in-one-view/8966 "2025-06-11T15:53:06Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\ **Post date:** [June 11, 2025, 3:53pm UTC](https://community.fibery.io/t/sorting-multiple-databases-chronologically-in-one-view/8966/1 "2025-06-11T15:53:06Z")
This is similar to [Dates End for sorting (multiple databases)](https://community.fibery.io/t/dates-end-for-sorting-multiple-databases/4964) 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](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/a/af45074d1a409ea946b51a36cc7be6e9dac2fee8.png) 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? ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [June 11, 2025, 4:36pm UTC](https://community.fibery.io/t/sorting-multiple-databases-chronologically-in-one-view/8966/2 "2025-06-11T16:36:53Z")
Curious. What happens if you add the sort to each db individually? ---
**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\ **Post date:** [June 11, 2025, 5:50pm UTC](https://community.fibery.io/t/sorting-multiple-databases-chronologically-in-one-view/8966/3 "2025-06-11T17:50:08Z")
They sort in order within each database and stack on top of each other in the order of the databases in the screenshot ☹ ---
**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\ **Post date:** [July 23, 2025, 12:46pm UTC](https://community.fibery.io/t/sorting-multiple-databases-chronologically-in-one-view/8966/4 "2025-07-23T12:46:49Z")
Did some troubleshooting on why this wasn’t working. 3 of the databases have a date range without times in the “Dates” field But the Google Calendar integration uses Datetimes for the “Dates” field in one of the databases (the one for not-all-day events). I’ve added a feature request that can fix this [Expose Default Time Values in Date Ranges for Sorting](https://community.fibery.io/t/expose-default-time-values-in-date-ranges-for-sorting/9256) ---
**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\ **Post date:** [July 23, 2025, 1:30pm UTC](https://community.fibery.io/t/sorting-multiple-databases-chronologically-in-one-view/8966/5 "2025-07-23T13:30:50Z")
You can create a formula field that converts the date time to just a date in order for this to work. ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [July 23, 2025, 1:40pm UTC](https://community.fibery.io/t/sorting-multiple-databases-chronologically-in-one-view/8966/6 "2025-07-23T13:40:16Z")
> [@RonMakesSystems](#): > > You can create a formula field that converts the date time to just a date in order for this to work Might not be ideal if @helloitse wants to retain the time info to affect the sort order. ---
**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\ **Post date:** [July 23, 2025, 1:43pm UTC](https://community.fibery.io/t/sorting-multiple-databases-chronologically-in-one-view/8966/7 "2025-07-23T13:43:24Z")
Yeah that’s the workaround here. But I’ve too many databases and interconnected views now for this to be simple. There’s technical debt in how I built out Fibery because this was unclear a year ago. At some point I invested in creating Dates fields for all databases I want in this shared view but I also have Start Date fields and Start Time fields that overlap with other databases for different views than this one. ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/d/d3a04d40d470a35167a24963aa996eda6d5fda15.png) 🤕 Maybe Fibery AI can help. But I see this taking at least 2 hours.