Visualizing Date Ranges

Thinking about date ranges and how to filter on them can be challenging. You might create a filter and realize you have some unexpected items in your results.

So I created an interactive app as a sort of "cheat sheet" for whenever you need to work with date ranges.

Imagine you have the date range RangeMin to RangeMax that you want to work with. We can visualize this with the following way.

Each horizontal line represents a record's StartDate and EndDate. Click on the filter below to highlight which records will be included in the results.

Based on the selection you make, here would be the condition expression you would use (JavaScript):

Condition Expression

  Please select a date range filter...