# Filtering a Monthly Calendar
**URL:** https://community.glideapps.com/t/filtering-a-monthly-calendar/78060
**Category:** Ask for Help
**Created:** [November 20, 2024, 12:44pm UTC](https://community.glideapps.com/t/filtering-a-monthly-calendar/78060 "2024-11-20T12:44:48Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Glider10](https://community.glideapps.com/u/Glider10)
#### Post date: [November 20, 2024, 12:44pm UTC](https://community.glideapps.com/t/filtering-a-monthly-calendar/78060/1 "2024-11-20T12:44:48Z")
I’m working on an exercise (running) app that is based off of a monthly point system. When I look at the monthly leaderboard, I get the users entire workout history and it brings in multiple months.
How can I filter the leaderboard to only read workouts that happened in November? Or October, etc?
Thank you!!
---
### Author:  [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [November 20, 2024, 3:44pm UTC](https://community.glideapps.com/t/filtering-a-monthly-calendar/78060/2 "2024-11-20T15:44:15Z")
You can create a Date Format computed column in the same table:
In the user profile table, create a column for the selected filter:
You can set it as user-specific, but it doesn’t really matter.
Create a table with month names:
In the main data table, add an if then else column to tell if the data must be shown or not:
In the layout editor, add a choice component and set the source to the month names table. Write to the user profile → selected filter that you created earlier:
If you want to filter with multiple months, check the “allow selecting multiple” option.
On the collection, set a filter with a single option:
Voilà!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 21, 2024, 12:58am UTC](https://community.glideapps.com/t/filtering-a-monthly-calendar/78060/3 "2024-11-21T00:58:44Z")
> [@Glider10](#):
>
> How can I filter the leaderboard to only read workouts that happened in November? Or October, etc?
Wouldn’t you want November 2024, October 2024 instead of just the month?
---
### Author:  [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [November 21, 2024, 2:05am UTC](https://community.glideapps.com/t/filtering-a-monthly-calendar/78060/4 "2024-11-21T02:05:21Z")
If you do @Glider10, just add YYYY to the template
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [November 21, 2024, 3:27am UTC](https://community.glideapps.com/t/filtering-a-monthly-calendar/78060/5 "2024-11-21T03:27:42Z")
Inspiration:
> [@🗓️ Dynamically filter an inline list by TIMEFRAME (Parts 1 & 2)!](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671):
>
> wave Hey fellow Gliders! In this video, learn how to dynamically filter a list of records by timeframes (day, week, month, etc.) using a Choice component, some Math columns and a Make Array column. Also features the concept of a “Work Table” to keep your data tables lean! popcorn Enjoy! Part 1 [[Glide: Dynamically Filter your Data by TIMEFRAMES (Part 1)] ](https://www.youtube.com/watch?v=pApLeMYHFzE)Part 2 [[Glide: Dynamically Filter your Data by DATE RANGE (Part 2)] ](https://www.youtube.com/watch?v=AVSavEhdt6Y)
---
### Author:  [@Luther](https://community.glideapps.com/u/Luther)
#### Post date: [November 21, 2024, 5:44am UTC](https://community.glideapps.com/t/filtering-a-monthly-calendar/78060/6 "2024-11-21T05:44:34Z")
This is still my go to post everytime i have to work with dates filtering 🤩 Gold
---
### Author:  [@Glider10](https://community.glideapps.com/u/Glider10)
#### Post date: [November 22, 2024, 10:00pm UTC](https://community.glideapps.com/t/filtering-a-monthly-calendar/78060/7 "2024-11-22T22:00:39Z")
Thanks y’all! I love this community. Worked quite well!