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.

Select a Date Range Filter Starts before RangeMin Starts after RangeMin Starts before RangeMax Starts after RangeMax Ends before RangeMin Ends after RangeMin Ends before RangeMax Ends after RangeMax Starts or ends inside the Range Starts or ends outside the Range Anything that is inside the Range Anything that is outside the Range Anything that involves the Range

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

Condition Expression

  Please select a date range filter...