Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Restrict LOOKUP to record with max value in field

Topic Labels: Formulas
Solved
Jump to Solution
666 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello!

I’m looking for a way to restrict a lookup to only the record with the max date in a date field.

Context: Managing a vehicle fleet

Bases:

  1. Registration
    Screen Shot 2021-07-14 at 2.37.43 PM

  2. VIN
    Screen Shot 2021-07-14 at 2.37.49 PM

Desired outcome
Only display the license plate that is associated with the registration record that has the max “license plate exp date” value.

I’m not sure how to go about this. Seems like there may be a way to do so by

  1. creating a view in the registration base that only shows the records with the most recent
  2. restricting the lookup to that view

but can’t figure out the first step there.

Any help appreciated.

1 Solution

Accepted Solutions

See this thread, but do the latest date instead of earliest date:

See Solution in Thread

1 Reply 1

See this thread, but do the latest date instead of earliest date: