How to group by rows in the filter view?

[zephir]

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

[Hassan_Nadeem]

Use Date format column since the actual date column also includes the time that’s why several rows are displayed.

Step 1:

Step 2:

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.

[ThinhDinh]

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.

[Hassan_Nadeem]

I always prefer Format Date column so I can format the date accordingly but yes I think template can also work.

[ThinhDinh]

Always test that column extensively on all OS, especially iOS, since it has proven to be a problem in the past.

[Darren_Murphy]

@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.

[Hassan_Nadeem]

I have used that over 100 of my apps. Didn’t know there was a risk.

[Darren_Murphy]

Time Format

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…