Help

Laste dates formula

1298 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