
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 07, 2021 01:31 PM
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!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 09, 2021 03:05 AM
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. |

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 09, 2021 03:05 AM
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. |
