Displaying date after last comma in a string

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!

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.
2 Likes

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.