Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Display records in between Start and End dates of another table

Topic Labels: Formulas
354 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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: