# How to group by rows in the filter view? **URL:** \ **Category:** Ask for Help\ **Created:** [July 8, 2023, 11:52pm UTC](https://community.glideapps.com/t/how-to-group-by-rows-in-the-filter-view/63687 "2023-07-08T23:52:59Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![zephir](https://avatars.discourse-cdn.com/v4/letter/z/e95f7d/32.png) [@zephir](https://community.glideapps.com/u/zephir)\ **Post date:** [July 8, 2023, 11:52pm UTC](https://community.glideapps.com/t/how-to-group-by-rows-in-the-filter-view/63687/1 "2023-07-08T23:52:59Z")
Hi , I have activated a date column in App filter. In the filter panel, for the same day, several rows are displayed. Is it possible to discard the duplicated rows ? Date Column is - type : Date & Time - Parts : Date only - Date format : short ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/5/e52dd8ff447ecb6634c1ccfaf68fb4dee00db6ed.png) ---
**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\ **Post date:** [July 9, 2023, 12:07am UTC](https://community.glideapps.com/t/how-to-group-by-rows-in-the-filter-view/63687/2 "2023-07-09T00:07:21Z")
Use **Date format** column since the actual date column also includes the time that’s why several rows are displayed. Step 1: ![Date Filter 1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/7/3756109d71dd17e8851ffafe4279267b015282cf.png) Step 2: ![Date Filter 2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/560f361b3b80320b9b3cf82f4eb60c4ddca1f7fd.png) We have to get rid of time when using the Date Format column to apply the filter because time is not unique in each row. ---
**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:** [July 9, 2023, 12:28am UTC](https://community.glideapps.com/t/how-to-group-by-rows-in-the-filter-view/63687/3 "2023-07-09T00:28:35Z")
I think you can just have a template column pointing to your date column to “lock” the format in, then use that in your filter. ---
**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\ **Post date:** [July 9, 2023, 12:50am UTC](https://community.glideapps.com/t/how-to-group-by-rows-in-the-filter-view/63687/4 "2023-07-09T00:50:11Z")
I always prefer Format Date column so I can format the date accordingly but yes I think template can also work. ---
**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:** [July 9, 2023, 2:28am UTC](https://community.glideapps.com/t/how-to-group-by-rows-in-the-filter-view/63687/5 "2023-07-09T02:28:07Z")
Always test that column extensively on all OS, especially iOS, since it has proven to be a problem in the past. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 9, 2023, 3:26am UTC](https://community.glideapps.com/t/how-to-group-by-rows-in-the-filter-view/63687/6 "2023-07-09T03:26:11Z")
> [@Hassan\_Nadeem](#): > > I always prefer Format Date column so I can format the date accordingly What he said 👇 > [@ThinhDinh](#): > > Always test that column extensively on all OS, especially iOS, since it has proven to be a problem in the past. Use that column at your own risk. It might work 99.99% of the time, but that one time it breaks it will take you days to figure out whats going wrong. ---
**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\ **Post date:** [July 9, 2023, 10:24am UTC](https://community.glideapps.com/t/how-to-group-by-rows-in-the-filter-view/63687/7 "2023-07-09T10:24:08Z")
I have used that over 100 of my apps. Didn’t know there was a risk. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 9, 2023, 10:33am UTC](https://community.glideapps.com/t/how-to-group-by-rows-in-the-filter-view/63687/8 "2023-07-09T10:33:44Z")
> [@Time Format](https://community.glideapps.com/t/time-format/50074/8): > > The other thing you need to do is test it at different times of the year. Early on, when I was trying to use it, I found that it would sometimes get the day and month mixed up, but only under certain circumstances, and only if the date was ambiguous. For example, today is September 25th. In the US, they write that as 9/25/2022. In the real world, we write it as 25/9/2022. But either way, it’s obvious that it’s September 25. It can’t be anything else, because there is no 25th month. But, le… ---
**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:** [July 10, 2023, 10:34am UTC](https://community.glideapps.com/t/how-to-group-by-rows-in-the-filter-view/63687/9 "2023-07-10T10:34:04Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.