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

Get Help
1

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?

2

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

3

Sweet, thanks! Easier than I was imagining actually. :slight_smile: