Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Laste dates formula

2132 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Aldo_Resta
4 - Data Explorer
4 - Data Explorer

I got two relate tables (bases).
table A with fields including a field to pick up date(s) fields from table B (multiple dates)
table B with date fields (column).
I need to insert a formula fields (column) with result the last date (1 result) from related table B.
Example in base A in the field “dates” i’ve got 5/11/2016, 6/11/2018, 9/12/2017 (picked up from tabel B)
In base A i need a formula field “last date” with the nearest (or greatest) date 6/11/2018

How can i get that?

Thnak you

3 Replies 3

You can use the MAX(value1, value2...) function in a formula.

MAX(Dates)

Or you can do this in a Rollup field in Table A. Instead of using a “Lookup” field to pull dates in from Table B, use a Rollup field that uses the MAX(values) Rollup function.

Aldo_Resta
4 - Data Explorer
4 - Data Explorer

yeah! it works with the Rollup
Thank you so much Jeremy

Yorgo_Bougas
4 - Data Explorer
4 - Data Explorer

Hello guys
I have a Rollup with Max and it returns a wrong date!
The Max date returned by Rollup is always a day less than the largest date value in the source table field.
I’ve tried to reformat, etc. - and nothing seems to help - it’s consistently a day behind
What gives?
thanks for your time