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
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.
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
