![mzah8 mzah8](https://community.airtable.com/legacyfs/online/avatars/2X/2/2a69e6c7519a8a95c8f192b7a4606d6c5bff5937.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 10, 2017 08:52 PM
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:
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![](/skins/images/75AB00B4920FD2D67A8CABF77C9DECC4/responsive_peak/images/icon_anonymous_message.png)