Help

Displaying date after last comma in a string

Topic Labels: Formulas
Solved
Jump to Solution
865 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Club_Agency
4 - Data Explorer
4 - Data Explorer

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
Databaser
12 - Earth
12 - Earth

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
Databaser
12 - Earth
12 - Earth

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.