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.


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.

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