# Filtering by Date Range - combined fixed and custom ranges

**URL:** <https://community.glideapps.com/t/filtering-by-date-range-combined-fixed-and-custom-ranges/33016>\
**Category:** Project Showcase\
**Created:** [October 13, 2021, 10:35am UTC](https://community.glideapps.com/t/filtering-by-date-range-combined-fixed-and-custom-ranges/33016 "2021-10-13T10:35:10Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**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:** [October 13, 2021, 10:35am UTC](https://community.glideapps.com/t/filtering-by-date-range-combined-fixed-and-custom-ranges/33016/1 "2021-10-13T10:35:10Z")

</div>

I’ve been playing around with different techniques for filtering records by date range, and have managed to develop a method for combining a set of fixed date ranges together with an option for setting a custom date range.

It’s a little complicated, but not too bad 😉

If anyone would like to see how this is done, let me know and I can probably put together a tutorial.

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [October 13, 2021, 11:17am UTC](https://community.glideapps.com/t/filtering-by-date-range-combined-fixed-and-custom-ranges/33016/2 "2021-10-13T11:17:23Z")

</div>

@Darren_Murphy

I’d like to see how it’s done!

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [January 24, 2024, 10:45am UTC](https://community.glideapps.com/t/filtering-by-date-range-combined-fixed-and-custom-ranges/33016/3 "2024-01-24T10:45:54Z")

</div>

Hey @Darren_Murphy could you please let me know as to how you achieved this? or pass me tutorial link?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [January 24, 2024, 11:42pm UTC](https://community.glideapps.com/t/filtering-by-date-range-combined-fixed-and-custom-ranges/33016/4 "2024-01-24T23:42:28Z")

</div>

> [@Date Formula Help](https://community.glideapps.com/t/date-formula-help/69621/3):
>
> Here is a [loom](https://www.loom.com/share/e763ec1ae22244529c53a975ae3b03f1) that may help get you started without doing anything too fancy. This uses a second table using the query column to bring in bills that fall within the date range. Again, not a full solution but might get you started.

This might help to get you started with a query column, which was not available when Darren made the feature above, I believe.

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [January 25, 2024, 3:55am UTC](https://community.glideapps.com/t/filtering-by-date-range-combined-fixed-and-custom-ranges/33016/5 "2024-01-25T03:55:45Z")

</div>

@ThinhDinh thank you for responding. I was able to get the data from one table.

But my dilemma is how do I get value from another table?

I need data accessed from multiple tables to check for the date range.

Could you please advise me?

Thank you in advance