Skip to main content

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.

Reply


Terms & Conditions