# Date Ranges

**URL:** <https://community.glideapps.com/t/date-ranges/67926>\
**Category:** Ask for Help\
**Created:** [November 18, 2023, 6:02pm UTC](https://community.glideapps.com/t/date-ranges/67926 "2023-11-18T18:02:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Javier\_SBT](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/javier_sbt/32/60802_2.png) [@Javier\_SBT](https://community.glideapps.com/u/Javier_SBT)\
**Post date:** [November 18, 2023, 6:02pm UTC](https://community.glideapps.com/t/date-ranges/67926/1 "2023-11-18T18:02:56Z")

</div>

Good afternoon, we have had to rethink a prototype that we were testing in GLIDE in which we had several tables (one for each month of the year) in which we recorded the activity times of operators of a service company, and now we do it on a SINGLE table in which to record all the times of the operators’ reports and previously identifying the date in each row (DD/MM/YYYY).

But now we need to solve how to show subtotals of operator times by month or by date ranges from the date reported in said single table.

We have tried to solve it without success and we have also tried to search for information in the community but we have not found it.

Could someone guide us???

Thanks in advance  
Javier

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [November 18, 2023, 11:30pm UTC](https://community.glideapps.com/t/date-ranges/67926/2 "2023-11-18T23:30:27Z")

</div>

This might give you a good start:

> [@🗓️ 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)

---

<div class="post-metadata">

**Author:** ![Javier\_SBT](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/javier_sbt/32/60802_2.png) [@Javier\_SBT](https://community.glideapps.com/u/Javier_SBT)\
**Post date:** [November 19, 2023, 7:45am UTC](https://community.glideapps.com/t/date-ranges/67926/3 "2023-11-19T07:45:08Z")

</div>

Thank you very much @Robert_Petitto for the link. That’s what I needed 😉

Thanks again for your help.

Greetings,  
Javier