Help

Display records in between Start and End dates of another table

Topic Labels: Formulas
628 1
cancel
Showing results for 
Search instead for 
Did you mean: 
kb9132
4 - Data Explorer
4 - Data Explorer

Hi, I need some help creating a formula.

I currently have the following set up:

Table1

  • Primary column = text
  • Start column = date
  • End column = date

Table2

  • Primary column = date
  • Notes column = text

In Table1, I’d like to display what Table2 records exist that are in between the Start and End dates for each Table1 record.

Any advice would be appreciated!

1 Reply 1

That is not possible in Airtable. You might be able to create a custom Javascript to do something like that for you. The same question was asked in this thread: