# Weekly overview **URL:** \ **Category:** Ask for Help\ **Created:** [January 21, 2023, 10:03am UTC](https://community.glideapps.com/t/weekly-overview/56955 "2023-01-21T10:03:57Z")\ **Posts on this page:** 10\ **Page:** 2
**Author:** ![B\_Estrada](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/b_estrada/32/83018_2.png) [@B\_Estrada](https://community.glideapps.com/u/B_Estrada)\ **Post date:** [December 12, 2024, 2:14am UTC](https://community.glideapps.com/t/weekly-overview/56955/22 "2024-12-12T02:14:52Z")
Hello, this worked great for me. How can I do the same for a monthly overview? Thanks ---
**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:** [December 12, 2024, 11:29am UTC](https://community.glideapps.com/t/weekly-overview/56955/23 "2024-12-12T11:29:09Z")
Use `Month(Date)` in a Math column. This will return a number between 1 and 12, where 1 is January and 12 is December. Then use similar if-then-else logic to that described in my original post. ---
**Author:** ![B\_Estrada](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/b_estrada/32/83018_2.png) [@B\_Estrada](https://community.glideapps.com/u/B_Estrada)\ **Post date:** [December 12, 2024, 10:30pm UTC](https://community.glideapps.com/t/weekly-overview/56955/24 "2024-12-12T22:30:49Z")
Thank you so much! ---
**Author:** ![B\_Estrada](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/b_estrada/32/83018_2.png) [@B\_Estrada](https://community.glideapps.com/u/B_Estrada)\ **Post date:** [December 13, 2024, 12:38am UTC](https://community.glideapps.com/t/weekly-overview/56955/25 "2024-12-13T00:38:47Z")
I’m actually having a little bit of trouble with this. Can I have an example if possible? Thanks! ---
**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:** [December 13, 2024, 12:54am UTC](https://community.glideapps.com/t/weekly-overview/56955/26 "2024-12-13T00:54:23Z")
Show me where you are getting stuck. ---
**Author:** ![B\_Estrada](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/b_estrada/32/83018_2.png) [@B\_Estrada](https://community.glideapps.com/u/B_Estrada)\ **Post date:** [December 13, 2024, 12:59am UTC](https://community.glideapps.com/t/weekly-overview/56955/27 "2024-12-13T00:59:38Z")
![Image 12-12-24 at 5.56 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/b/3b5e25087d64baafe7236c169fb973f97c447ad3.jpeg) The first column in the photo is the ‘Month(Date)’ formula. Now how can I use the if then else column to filter my timestamps by month? Thanks ---
**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:** [December 13, 2024, 1:04am UTC](https://community.glideapps.com/t/weekly-overview/56955/28 "2024-12-13T01:04:30Z")
Are you wanting to allow the user to select a month, and then filter by that month? ---
**Author:** ![B\_Estrada](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/b_estrada/32/83018_2.png) [@B\_Estrada](https://community.glideapps.com/u/B_Estrada)\ **Post date:** [December 13, 2024, 1:08am UTC](https://community.glideapps.com/t/weekly-overview/56955/29 "2024-12-13T01:08:26Z")
Not exactly. The users fill this form out and the timestamp populates when they submit it. I need to see how many forms were filled out in day, in a week, and in a month. So far I have the daily and weekly count. Now I just need to see how many forms were submitted this month. ---
**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:** [December 13, 2024, 1:13am UTC](https://community.glideapps.com/t/weekly-overview/56955/30 "2024-12-13T01:13:58Z")
ah, I see. Okay, I would modify that math formula so that it takes the year into account as well. Use the following: ```auto Year(Date)*10^2+Month(Date) ``` That will give you something like `202412`. Then create a second column exactly the same, except use the current DateTime (`Now`) as the input value. Then your if-then-else column becomes: - If Math Date equals Math Now, then `true` ---
**Author:** ![B\_Estrada](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/b_estrada/32/83018_2.png) [@B\_Estrada](https://community.glideapps.com/u/B_Estrada)\ **Post date:** [December 13, 2024, 1:32am UTC](https://community.glideapps.com/t/weekly-overview/56955/31 "2024-12-13T01:32:08Z")
This was exactly what I needed. Thank you, I appreciate the help! [Previous page](https://community.glideapps.com/t/weekly-overview/56955.md?page=1)