Forum Discussion

ReneeHansen's avatar
ReneeHansen
Qrew Member
3 years ago

MAX DATE FIELD

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

2 Replies

  • 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
    ------------------------------
    • ReneeHansen's avatar
      ReneeHansen
      Qrew Member

      That was something I should have known :(

      Thank you!!!! :)



      ------------------------------
      Renee Hansen
      ------------------------------