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

Displaying date after last comma in a string

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

Hey Everyone!

I have a lookup column with dates like this 5/30/2020, 5/29/2020, 5/15/2020, 5/7/2020, 9/21/2020, 11/27/2020

I need to only show the last date.

I also need one for only showing the first date.

Thanks!

1 Solution

Accepted Solutions

Hi @Club_Agency and welcome to the community!

You should use a “rollup” field instead of a “lookup” field. Then you can use the “max” and “min” functions to get the dates.

MAX Returns the largest of the given values.
MIN Returns the smallest of the given values.

See Solution in Thread

1 Reply 1

Hi @Club_Agency and welcome to the community!

You should use a “rollup” field instead of a “lookup” field. Then you can use the “max” and “min” functions to get the dates.

MAX Returns the largest of the given values.
MIN Returns the smallest of the given values.