In-app filter for only date data

Hi there,

I have so many date&time data. And I added one more column to display only date for use in in-app filter. Anyway, it doesn’t display only single date. It displays duplicate date.
How to solve this problem?

What type of column is this?

The column I made in-app filter is Math. Because I would like to filter out time data from date&time column

Even if you use a math column to change the format, it will still contain the underlying time. Formatting is only for visual purposes. It does not change the actual value.

Try adding a template column that redisplays the math column. It will lock in the formatting and convert it to text without the time included.

1 Like