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]

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] Step 2: [Date Filter 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.

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.

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

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

[image] Hassan_Nadeem: I always prefer Format Date column so I can format the date accordingly What he said :point_down: [image] 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.

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

[image] Time Format Ask for Help 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…

How to group by rows in the filter view?

Ask for Help

Darren_Murphy July 9, 2023, 10:33am 8

Topic		Replies	Views
In-app filter for only date data Ask for Help	3	45	September 19, 2025
Visibility "is within" some other field Feature Requests	10	317	August 17, 2020
Date & time column value from a relation Report a Bug	2	516	June 21, 2020
Split Date Entry Component into multiple sub fields Feature Requests	20	1975	September 9, 2020
Filter Data by Date when Column Type isn't Date & Time Ask for Help	14	959	December 13, 2022

How to group by rows in the filter view?

Related topics