Create a field/view to show records relevant to a date range

[mzah8]

Sorry for the topic title, I wasn’t sure how to describe this.

So what I have is a base of appointments, and I have ‘Date Appointed’ and "last Date of Appointment’ columns.

The third column, ‘Years Active’, is a calculated field that tells me the years applicable for this appointment. So above, for the appointment from 16/12/2010 and 2/11/2015, the years applicable would be 2010 to 2015.

Currently it just concatenates the beginning and end years from the first two columns.

But I’d actually like if I could get an output like a comma-separated string, so instead of ‘2010 - 2015’, it would show ‘2010, 2011, 2012, 2013, 2014, 2015’. This is to enable filtering such as ‘Years Active contains 2013 and 2014’.

I was reading the documentation and browsing the forums, but the closest I found is that in the thread IF-formula. If all fields = X, then Y, it was said that “creating” arrays in not possible in Airtable:

IF-formula. If all fields = X, then Y

This is where I wish that Airtable allowed “creating” arrays. Then we could build an array from the values of the various columns and then use ARRAYUNIQUE and a few IF statements. But alas, all we’re left with is clunky solutions like this one.

I could of course create a checkbox column for each year. But I’m wondering if there is a better, more automated way to show what I want?

Thanks!

Create a field/view to show records relevant to a date range