Discussions

Expand all | Collapse all

FInd Max Date for When Field Value is the same but record # is different

  • 1.  FInd Max Date for When Field Value is the same but record # is different

    Posted 16 days ago
    Edited by Mackenzie Phillips 16 days ago

    Hello,

    I have a table that represents the same logic as below:

    Record ID |  Name | Date

    1                 | Fred    | 12/1/20

    2                 | Fred    | 12/2/21

    3                 | Joe      | 6/7/19

    4                 | Joe      | 8/16/21

    5                 | Sam    |  2/7/20

    I need some way to summarize the Maximum date when the name field is the same. I want another column that would populate a field in all columns containing "Fred" with 12/2/21, Freds Max date. So it would look like below:

    Record ID |  Name | Date        | Max Date

    1                 | Fred    | 12/1/20  | 12/2/21

    2                 | Fred    | 12/2/21  |  12/2/21

    3                 | Joe      | 6/7/19    | 8/16/21

    4                 | Joe      | 8/16/21  | 8/16/21

    5                 | Sam    |  2/7/20    | 2/7/20



    ------------------------------
    Mackenzie Phillips
    ------------------------------


  • 2.  RE: FInd Max Date for When Field Value is the same but record # is different

    Posted 16 days ago
    The only way to do that negatively is to have a table of names where there is a relationship where one name has many detail records. Then you would be able to summarize the maximum date.
    You can make a table of the unique value for names using a summary report and then copying those records to another table, but the question will be how will you maintain the table of unique names going forward. There are different automated approaches to this


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