Reference a date range in a billing schedule table to update billing date in claim table

Topic Labels: Base design Formulas
281 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hello, I am trying to automatically update the "Bill Date" based on the date of incoming claims. The bill date is based on a start and end date and all three dates are recorded in a different table for billing schedule. How do I create a if claim date on my main table is between the two date in the billing table? In excel this would be simple, but having an issue with looking up on a different table in airtable. Thanks!

1 Reply 1

Could you provide some examples please?