# Filter through Months

**URL:** <https://community.glideapps.com/t/filter-through-months/31705>\
**Category:** Ask for Help\
**Created:** [September 13, 2021, 8:33am UTC](https://community.glideapps.com/t/filter-through-months/31705 "2021-09-13T08:33:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\
**Post date:** [September 13, 2021, 8:33am UTC](https://community.glideapps.com/t/filter-through-months/31705/1 "2021-09-13T08:33:55Z")

</div>

My data contains monthly figures from July-2021 to June-2022. I want my app to view this months data. Why is there not a feature of viewing month “is” todays date?. Viewing “Todays” option is for every category except “is” category.

---

<div class="post-metadata">

**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\
**Post date:** [September 13, 2021, 8:38am UTC](https://community.glideapps.com/t/filter-through-months/31705/2 "2021-09-13T08:38:27Z")

</div>

if I understand correctly, to solve you should, in a new column, calculate the current month and filter according to your needs.  
Use this formula in the math column:  
MONTH (your date column)