# Time Format Not Displaying and Table Grouping Problem **URL:** \ **Category:** Ask for Help\ **Created:** [March 3, 2026, 4:05am UTC](https://community.glideapps.com/t/time-format-not-displaying-and-table-grouping-problem/86541 "2026-03-03T04:05:07Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Arrafi\_Wardhana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arrafi_wardhana/32/93726_2.png) [@Arrafi\_Wardhana](https://community.glideapps.com/u/Arrafi_Wardhana)\ **Post date:** [March 3, 2026, 4:05am UTC](https://community.glideapps.com/t/time-format-not-displaying-and-table-grouping-problem/86541/1 "2026-03-03T04:05:07Z")
I noticed a problem where some devices doesnt display the formatted date and time. this was when i used the Experimental Date Format column and put it on a template column. however, some devices only see it as ( - ) instead of (x - z). so i decided to change the approach with Math Column, ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/e/fede398fc8c9832c19404a087333ee1e3e75b396.png) but now a second problem occured, my table collection grouping doesnt sort from A-Z. targeting my template column to the original Date & Time column does the same. so the Group Sorting only works when I use Experimental Date Format. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/6/b6fa0217b4770a290818fa57a41262fb4954592b.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/b/fb97a763f1d9d18f9d3ee1b40d2945887a905dd4.png) any idea whats going on? ---
**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:** [March 4, 2026, 12:18am UTC](https://community.glideapps.com/t/time-format-not-displaying-and-table-grouping-problem/86541/2 "2026-03-04T00:18:26Z")
Experimental Format Date doesn’t work consistently across devices, it’s been a problem for years so I don’t really recommend using it extensively. Seeing that you have a Start Time column as basic, I would try still grouping by that but sort by the Start Time. I recall a bug with a certain component that doesn’t sort correctly, maybe it’s this, but would suggest giving sorting by Start Time to see if it helps. ---
**Author:** ![Arrafi\_Wardhana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arrafi_wardhana/32/93726_2.png) [@Arrafi\_Wardhana](https://community.glideapps.com/u/Arrafi_Wardhana)\ **Post date:** [March 4, 2026, 1:47pm UTC](https://community.glideapps.com/t/time-format-not-displaying-and-table-grouping-problem/86541/3 "2026-03-04T13:47:06Z")
im doing this from a relation, so sorting through the Start Time would sort the inline list and not the grouping itself. im guessing a certain fix woould be retargeting the table source? ---
**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:** [March 5, 2026, 12:01am UTC](https://community.glideapps.com/t/time-format-not-displaying-and-table-grouping-problem/86541/4 "2026-03-05T00:01:57Z")
Wouldn’t the sort have to apply to groupings as well? If it’s not, it’s a bug imo. ---
**Author:** ![Arrafi\_Wardhana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arrafi_wardhana/32/93726_2.png) [@Arrafi\_Wardhana](https://community.glideapps.com/u/Arrafi_Wardhana)\ **Post date:** [March 5, 2026, 4:25am UTC](https://community.glideapps.com/t/time-format-not-displaying-and-table-grouping-problem/86541/5 "2026-03-05T04:25:59Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/2/d23246638c4f781b3d672f509db7f6ce4c7a01c0.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/e/7ea19b0c0d9e7871a05efe010ed1ff1109d3f356.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/df30d8fb45335adfb4e778ab058d24443e3acd04.png) I tried sorting back and forth, and it seems the problem lies not on the grouping, but the display order itself. I took out the grouping and sort the data though the Display Template Column, and the table order is still mixed, this happens both when I populate the Template Column with Experimental Date Format, or native Date & Time Column. would this give a better sense to what the problem actually is? I reckon its a bug since everything used is native. ---
**Author:** ![Arrafi\_Wardhana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arrafi_wardhana/32/93726_2.png) [@Arrafi\_Wardhana](https://community.glideapps.com/u/Arrafi_Wardhana)\ **Post date:** [March 5, 2026, 4:34am UTC](https://community.glideapps.com/t/time-format-not-displaying-and-table-grouping-problem/86541/6 "2026-03-05T04:34:24Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/0/409b3fc9bcb086d8f000c46517b840aae76cf55b.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/9/d95aa18704aa21eeb27da63baeea4ad740106690.png) Here’s a test where I populate with Number and it works fine. so the second its populated with Date & Time, it scrambles (tried Respect Time Zone too) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 5, 2026, 4:35am UTC](https://community.glideapps.com/t/time-format-not-displaying-and-table-grouping-problem/86541/7 "2026-03-05T04:35:55Z")
Display is an alpha-numeric column, so it’s going to sort alphabetically instead of numerically. Alphabetically, 1 comes before 7 regardless if it’s actually 11. If you want it to sort correctly, you need to sort by a numeric column. ---
**Author:** ![Arrafi\_Wardhana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arrafi_wardhana/32/93726_2.png) [@Arrafi\_Wardhana](https://community.glideapps.com/u/Arrafi_Wardhana)\ **Post date:** [March 5, 2026, 7:45am UTC](https://community.glideapps.com/t/time-format-not-displaying-and-table-grouping-problem/86541/8 "2026-03-05T07:45:13Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/c/6c34e60ad000182c95c57b26e0e35ed82812d0d4.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/c/cca6d7a0235569079c3c6417368c6e7a127f58b5.png) I see, how would you recommend fixing the group sorting? I tried to sort the data through numeric column but it sorts only the inline list ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 5, 2026, 12:56pm UTC](https://community.glideapps.com/t/time-format-not-displaying-and-table-grouping-problem/86541/9 "2026-03-05T12:56:14Z")
To be clear, have you tried sorting by the Start Time column? I think that’s what @ThinhDinh suggested, but I can’t see that you tried it in your screenshots. ---
**Author:** ![Arrafi\_Wardhana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arrafi_wardhana/32/93726_2.png) [@Arrafi\_Wardhana](https://community.glideapps.com/u/Arrafi_Wardhana)\ **Post date:** [March 6, 2026, 6:25am UTC](https://community.glideapps.com/t/time-format-not-displaying-and-table-grouping-problem/86541/10 "2026-03-06T06:25:22Z")
yes i have, tested with: 1. Experimental Date Format 2. Native Date & Time 3. Math Column (Hour) all the options above - sort by descending nor ascending, doesn’t seem to change anything, output is as the pic below. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/f/3f8b8d90653056a47ff963b5dfef4b31939b60e8.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:** [March 6, 2026, 11:31pm UTC](https://community.glideapps.com/t/time-format-not-displaying-and-table-grouping-problem/86541/11 "2026-03-06T23:31:26Z")
![CleanShot 2026-03-07 at 06.30.57](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/0/80fa8af90d48c3c07dee9ff3f8bc13348619b145.png) I mean sorting by this column, since Glide might see that as a number on the backend. Is that what you tried for the “Native Date & Time” scenario? ---
**Author:** ![Arrafi\_Wardhana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arrafi_wardhana/32/93726_2.png) [@Arrafi\_Wardhana](https://community.glideapps.com/u/Arrafi_Wardhana)\ **Post date:** [March 7, 2026, 4:37pm UTC](https://community.glideapps.com/t/time-format-not-displaying-and-table-grouping-problem/86541/12 "2026-03-07T16:37:48Z")
yess indeed thats what i tried ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 7, 2026, 4:43pm UTC](https://community.glideapps.com/t/time-format-not-displaying-and-table-grouping-problem/86541/13 "2026-03-07T16:43:35Z")
if you click on a cell in that starttime column, do you have different dates? Just because you set the format to date only doesn’t mean the underlying date isn’t still being factored in. I’m betting you have different dates in each cell. I’m betting you also have issue with the math column because you are attaching :00 to a number which converts it to text. Try removing units from the math column so you have a pure numeric value instead of a number with characters appended to it. Then try sorting by the math column. ---
**Author:** ![Arrafi\_Wardhana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arrafi_wardhana/32/93726_2.png) [@Arrafi\_Wardhana](https://community.glideapps.com/u/Arrafi_Wardhana)\ **Post date:** [March 7, 2026, 6:12pm UTC](https://community.glideapps.com/t/time-format-not-displaying-and-table-grouping-problem/86541/14 "2026-03-07T18:12:35Z")
i set it to Time only ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/1/614dac8a6b6a064bf83e94ee6496d8f379bde0a2.png) here is the underlying date if i format it to date and time ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/b/cb02af06b8ecab1b7dcdf82053a2b04be31cdc00.png) the math column supposed to look like this then right? tried removing the units then sorting through this but nothing seems to change… this is getting a bit weird so thank you for hanging around ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/a/eaa02fd6e645788549bc79a1e1a4832c58fef2f8.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:** [March 9, 2026, 12:05am UTC](https://community.glideapps.com/t/time-format-not-displaying-and-table-grouping-problem/86541/15 "2026-03-09T00:05:25Z")
How did you originally enter data into that column? Is it through a form? ---
**Author:** ![Arrafi\_Wardhana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arrafi_wardhana/32/93726_2.png) [@Arrafi\_Wardhana](https://community.glideapps.com/u/Arrafi_Wardhana)\ **Post date:** [March 9, 2026, 2:01am UTC](https://community.glideapps.com/t/time-format-not-displaying-and-table-grouping-problem/86541/16 "2026-03-09T02:01:43Z")
no i manually populate it in the data editor ---
**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:** [March 10, 2026, 12:06am UTC](https://community.glideapps.com/t/time-format-not-displaying-and-table-grouping-problem/86541/17 "2026-03-10T00:06:42Z")
Is it possible to send a link to join your team in private messages and tell me where to navigate to get to the relevant screen? Thank you. ---
**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:** [March 10, 2026, 8:06am UTC](https://community.glideapps.com/t/time-format-not-displaying-and-table-grouping-problem/86541/18 "2026-03-10T08:06:35Z")
@Arrafi_Wardhana @Jeff_Hager I believe this is a known bug with the Table component’s grouping. ![CleanShot 2026-03-10 at 15.03.41](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/9/7983938aefa904ae152ad196d0dca7e50c28f00c.png) ![CleanShot 2026-03-10 at 15.04.13](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/7/877849c299b16ec6520b379090d24ed91277b9ea.png) This is that same table, not grouped, sorted by the start time. ![CleanShot 2026-03-10 at 15.06.14](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/2/62f220caedec6b518a966e24d15ae580883d6c51.png) When you do the Grouping, it sorts the groupings and ignore everything else, hence you see the "1"s first, then 6 and then 8. ---
**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:** [March 10, 2026, 8:07am UTC](https://community.glideapps.com/t/time-format-not-displaying-and-table-grouping-problem/86541/19 "2026-03-10T08:07:24Z")
Unfortunately I believe this bug has been around for a long time and the team has not fixed it. I would suggest using another type of collection, perhaps. ---
**Author:** ![Arrafi\_Wardhana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arrafi_wardhana/32/93726_2.png) [@Arrafi\_Wardhana](https://community.glideapps.com/u/Arrafi_Wardhana)\ **Post date:** [March 10, 2026, 9:29pm UTC](https://community.glideapps.com/t/time-format-not-displaying-and-table-grouping-problem/86541/20 "2026-03-10T21:29:13Z")
well that’s a bummer. thank you for resolving this