# In-app filter for only date data

**URL:** <https://community.glideapps.com/t/in-app-filter-for-only-date-data/84462>\
**Category:** Ask for Help\
**Created:** [September 19, 2025, 1:38am UTC](https://community.glideapps.com/t/in-app-filter-for-only-date-data/84462 "2025-09-19T01:38:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Plai\_Official](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/plai_official/32/89253_2.png) [@Plai\_Official](https://community.glideapps.com/u/Plai_Official)\
**Post date:** [September 19, 2025, 1:38am UTC](https://community.glideapps.com/t/in-app-filter-for-only-date-data/84462/1 "2025-09-19T01:38:47Z")

</div>

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?

---

<div class="post-metadata">

**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:** [September 19, 2025, 1:47am UTC](https://community.glideapps.com/t/in-app-filter-for-only-date-data/84462/2 "2025-09-19T01:47:19Z")

</div>

> [@Plai\_Official](#):
>
> I added one more column to display only date

What type of column is this?

---

<div class="post-metadata">

**Author:** ![Plai\_Official](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/plai_official/32/89253_2.png) [@Plai\_Official](https://community.glideapps.com/u/Plai_Official)\
**Post date:** [September 19, 2025, 1:54am UTC](https://community.glideapps.com/t/in-app-filter-for-only-date-data/84462/3 "2025-09-19T01:54:44Z")

</div>

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

---

<div class="post-metadata">

**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:** [September 19, 2025, 2:32am UTC](https://community.glideapps.com/t/in-app-filter-for-only-date-data/84462/4 "2025-09-19T02:32:09Z")

</div>

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.