# Sort by Time column not working in List Collection **URL:** \ **Category:** Report a Bug\ **Created:** [April 9, 2024, 8:32pm UTC](https://community.glideapps.com/t/sort-by-time-column-not-working-in-list-collection/72435 "2024-04-09T20:32:52Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Alejandro13](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alejandro13/32/61299_2.png) [@Alejandro13](https://community.glideapps.com/u/Alejandro13)\ **Post date:** [April 9, 2024, 8:32pm UTC](https://community.glideapps.com/t/sort-by-time-column-not-working-in-list-collection/72435/1 "2024-04-09T20:32:52Z")
**Team ID:** - ywgnmSFtyK3tbjrJCAiZ **App ID:** A2pUXoVH7aYCjReZo15W **Description** I have an app with List component. I’m trying to sort the data based on the Time column: Hora, that comes from a Glide table. This sorting is not working: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/f/bf01269da592f9baecb4fc318136fe27179cd471.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/9/a9bfbf5def49564c7dcbd1eff48cbd2c21edf670.png) Neither on asc or desc. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/e/be602588e55377b3d176a87d86221bbb215da376.png) This sorting was working before in this component, but when I migrated the app data from Google Sheets to Glide Tables (and therefore rebuilt it) this stopped working. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/7/f74d813d00330086dff317d924c9ee32c4babaf0.png) **How to replicate** 1. Create a list component from a Glide Table 2. Have a Time Only without seconds column in the Glide table 3. Try to sort the column by this field Thanks for your help! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 9, 2024, 11:45pm UTC](https://community.glideapps.com/t/sort-by-time-column-not-working-in-list-collection/72435/2 "2024-04-09T23:45:55Z")
Can you go to the data view, click on some of the cells in the Hora column, and screenshot them for us? My thinking is whilst you’re using “Time Only”, the underlying value still has a date, so that’s what it’s sorting. ---
**Author:** ![Alejandro13](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alejandro13/32/61299_2.png) [@Alejandro13](https://community.glideapps.com/u/Alejandro13)\ **Post date:** [April 10, 2024, 3:03pm UTC](https://community.glideapps.com/t/sort-by-time-column-not-working-in-list-collection/72435/3 "2024-04-10T15:03:26Z")
Sure @ThinhDinh , here are some screenshots: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/d/2d6fd39ff8d995982ac2c33b1eb05c1b7e69017e.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/5/95e36a7fb3044d22472ecdac20ee7627147fd79a.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 10, 2024, 11:11pm UTC](https://community.glideapps.com/t/sort-by-time-column-not-working-in-list-collection/72435/4 "2024-04-10T23:11:12Z")
So you have the date in a column, and the hour in another? Is there a reason you don’t have the date/time combined in one? Not that it is the reason for the bug here, thought I may ask. I would try to use a math column with the formula HOUR(T) with T being the “Hora” column, and sort by that column to see if it helps. ---
**Author:** ![Alejandro13](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alejandro13/32/61299_2.png) [@Alejandro13](https://community.glideapps.com/u/Alejandro13)\ **Post date:** [April 11, 2024, 5:07pm UTC](https://community.glideapps.com/t/sort-by-time-column-not-working-in-list-collection/72435/5 "2024-04-11T17:07:36Z")
I have them separated because the form that I use for getting this info gets this values independently in 2 different moments. I found the solution by sorting the values not in the list component, but in the page. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 11, 2024, 11:08pm UTC](https://community.glideapps.com/t/sort-by-time-column-not-working-in-list-collection/72435/6 "2024-04-11T23:08:31Z")
> [@Alejandro13](#): > > I found the solution by sorting the values not in the list component, but in the page. That sounds weird, can you elaborate more? Sorting on the page/tab level means you’re changing the row tied to the tab. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [April 18, 2024, 11:08pm UTC](https://community.glideapps.com/t/sort-by-time-column-not-working-in-list-collection/72435/7 "2024-04-18T23:08:47Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.