Sequential Missing Dates from Between two Date Values?

To generate a list of dates, you can adapt the technique shown below:

To filter between a start date and end date, you can use an if-then-else column:

  • If date is before start date, then null
  • If date is after end date, then null
  • Else true
2 Likes