# Filter data collection

**URL:** <https://community.glideapps.com/t/filter-data-collection/69995>\
**Category:** Ask for Help\
**Created:** [January 25, 2024, 7:17am UTC](https://community.glideapps.com/t/filter-data-collection/69995 "2024-01-25T07:17:59Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Stefania\_Oancea](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefania_oancea/32/60457_2.png) [@Stefania\_Oancea](https://community.glideapps.com/u/Stefania_Oancea)\
**Post date:** [January 25, 2024, 7:17am UTC](https://community.glideapps.com/t/filter-data-collection/69995/1 "2024-01-25T07:17:59Z")

</div>

Hello,  
Can someone tell me how to filter data to show me only the today’s registrations, without using “Data is within today” because it doesn’t work…

 ![REGISTRU](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/6/666c3ee09f1f93ce68da06fbee7ce89966b2e5b4.jpeg)

---

<div class="post-metadata">

**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:** [January 25, 2024, 7:31am UTC](https://community.glideapps.com/t/filter-data-collection/69995/2 "2024-01-25T07:31:18Z")

</div>

What I would do:

- In the User profile table, create a Math column using the following formula:

```auto
Year(Now) * 10^4
+ Month(Now) * 10^2
+ Day(Now)

```

- In the above, substitute the current date/time for “Now”.
- In your data table, create another column using the same math formula, but use the row date as a substitute instead of the current date/time
- Use both of those columns in your filter condition:  
– User Profile-\>Math equals Data-\>Math

---

<div class="post-metadata">

**Author:** ![Brij\_Mohan\_Sharma](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brij_mohan_sharma/32/63672_2.png) [@Brij\_Mohan\_Sharma](https://community.glideapps.com/u/Brij_Mohan_Sharma)\
**Post date:** [January 25, 2024, 7:51am UTC](https://community.glideapps.com/t/filter-data-collection/69995/3 "2024-01-25T07:51:42Z")

</div>

You can create a column in your sheet that will be boolean if the records has the today’s date then it will check the boolean value to True, Now come to the UI here you can use FILTER DATA and show values that is True. Now your task is only to create the dynamic column that will always have the today’s date. Also create a condition to check with the your record date with the column that will only have the today’s date to marks the boolean value to True only when your record date is same as the Today’s date. Hope you will find you solution there.

---

<div class="post-metadata">

**Author:** ![Stefania\_Oancea](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefania_oancea/32/60457_2.png) [@Stefania\_Oancea](https://community.glideapps.com/u/Stefania_Oancea)\
**Post date:** [January 25, 2024, 8:35am UTC](https://community.glideapps.com/t/filter-data-collection/69995/4 "2024-01-25T08:35:32Z")

</div>

Thank you very much!!!

---

<div class="post-metadata">

**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:** [February 1, 2024, 8:35am UTC](https://community.glideapps.com/t/filter-data-collection/69995/5 "2024-02-01T08:35:34Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.