# How to check if a \[date\] falls within a \[date range\]

**URL:** <https://community.fibery.io/t/how-to-check-if-a-date-falls-within-a-date-range/7802>\
**Category:** Get Help\
**Created:** [November 15, 2024, 2:59pm UTC](https://community.fibery.io/t/how-to-check-if-a-date-falls-within-a-date-range/7802 "2024-11-15T14:59:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\
**Post date:** [November 15, 2024, 2:59pm UTC](https://community.fibery.io/t/how-to-check-if-a-date-falls-within-a-date-range/7802/1 "2024-11-15T14:59:59Z")

</div>

I’m trying to use a formula to filter a collection of sprints that all have a date range field, by a specific date, so I can return the sprint where the specific date falls within.

So example:

If this was the collection of sprints:  
Sprint 1 - Production Period: Oct 28, 2024 - Nov 1, 2024  
Sprint 2 - Production Period: Nov 4, 2024 - Nov 8, 2024  
Sprint 3 - Production Period: Nov 11, 2024 - Nov 15, 2024

and the specific date was Nov 7, 2024, the formula would return Sprint 2, since the date falls within the Nov 4, 2024 to Nov 8, 2024 date range.

Is there a “simple” way to do this with a single formula?

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [November 15, 2024, 7:57pm UTC](https://community.fibery.io/t/how-to-check-if-a-date-falls-within-a-date-range/7802/2 "2024-11-15T19:57:27Z")

</div>

`Sprints.Filter([Production Date].Start() <= Date(2024,11,7) AND [Production Date].End() >= Date(2024,11,7))`

---

<div class="post-metadata">

**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\
**Post date:** [November 15, 2024, 8:44pm UTC](https://community.fibery.io/t/how-to-check-if-a-date-falls-within-a-date-range/7802/3 "2024-11-15T20:44:01Z")

</div>

Sweet, thanks! Easier than I was imagining actually. 🙂