# Filter inline list to current month

**URL:** <https://community.glideapps.com/t/filter-inline-list-to-current-month/3043>\
**Category:** Ask for Help\
**Created:** [December 20, 2019, 8:37pm UTC](https://community.glideapps.com/t/filter-inline-list-to-current-month/3043 "2019-12-20T20:37:24Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alysson\_Correa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alysson_correa/32/2114_2.png) [@Alysson\_Correa](https://community.glideapps.com/u/Alysson_Correa)\
**Post date:** [December 20, 2019, 8:37pm UTC](https://community.glideapps.com/t/filter-inline-list-to-current-month/3043/1 "2019-12-20T20:37:25Z")

</div>

Hey,  
I need to filter in the inline list (modo calendar) only the current month, how do I do it?

 ![calendar](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/ed268e0e8fdbee4bd732e52fab3a4e6747e437b3.jpeg)

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [December 20, 2019, 10:32pm UTC](https://community.glideapps.com/t/filter-inline-list-to-current-month/3043/2 "2019-12-20T22:32:33Z")

</div>

Put this formula on row 1 of a column on your sheet. Change the F2:F to the column you have your date in. Then filter on this column.

```auto
={"ThisMonth";ARRAYFORMULA(IF(LEN(F2:F),month(F2:F)=month(today()),""))}

```

 ![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9c8f5e7bd450882adb67698fe6621626ca47717a.png)

---

<div class="post-metadata">

**Author:** ![Alysson\_Correa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alysson_correa/32/2114_2.png) [@Alysson\_Correa](https://community.glideapps.com/u/Alysson_Correa)\
**Post date:** [December 20, 2019, 11:05pm UTC](https://community.glideapps.com/t/filter-inline-list-to-current-month/3043/3 "2019-12-20T23:05:14Z")

</div>

Great!!, tks George

---

<div class="post-metadata">

**Author:** ![Todd\_Peterson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_peterson/32/4202_2.png) [@Todd\_Peterson](https://community.glideapps.com/u/Todd_Peterson)\
**Post date:** [March 14, 2020, 2:13pm UTC](https://community.glideapps.com/t/filter-inline-list-to-current-month/3043/4 "2020-03-14T14:13:04Z")

</div>

Thanks George. This works great!!

---

<div class="post-metadata">

**Author:** ![Todd\_Peterson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_peterson/32/4202_2.png) [@Todd\_Peterson](https://community.glideapps.com/u/Todd_Peterson)\
**Post date:** [March 14, 2020, 8:02pm UTC](https://community.glideapps.com/t/filter-inline-list-to-current-month/3043/5 "2020-03-14T20:02:45Z")

</div>

George,  
How would I modify this formula for the current date instead of the month? Thanks

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [March 14, 2020, 8:16pm UTC](https://community.glideapps.com/t/filter-inline-list-to-current-month/3043/6 "2020-03-14T20:16:25Z")

</div>

I haven’t tested it but I’m pretty sure… just take out both occurrences of the word month.

---

<div class="post-metadata">

**Author:** ![Todd\_Peterson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_peterson/32/4202_2.png) [@Todd\_Peterson](https://community.glideapps.com/u/Todd_Peterson)\
**Post date:** [March 14, 2020, 8:23pm UTC](https://community.glideapps.com/t/filter-inline-list-to-current-month/3043/7 "2020-03-14T20:23:51Z")

</div>

Well that was simple. I tried everything but that. Thanks it works perfectly

---

<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:** [March 14, 2020, 9:51pm UTC](https://community.glideapps.com/t/filter-inline-list-to-current-month/3043/8 "2020-03-14T21:51:52Z")

</div>

Glide also has built in filtering to compare dates to Today…in case you are interested in a non formula solution.