MAX DATE FIELD

Question

Hi,I have a field that summarizes the Acquired date for our asset.
So this can have 2 or more dates summarized, but I want to have another field that just pulls the max date (most recent).

I know there's a MAX formula function, but I'm not sure how to make it works since it needs 2 or more fields.Here's a screenshot of the regular "acq date" field.
------------------------------Renee Hansen------------------------------

MarkShnierYou · Answer

Is your screen shot the result of a combined text summary field of the text version of a date field ? ie you have a relationship?

IF so, just go to that same relationship and make a summary of the maximum of the Acquisition Date field.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community