Skip to main content

Display records in between Start and End dates of another table

  • September 9, 2020
  • 1 reply
  • 19 views

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

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • September 10, 2020

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: