Discussions

Expand all | Collapse all

Working out the Latest Date

  • 1.  Working out the Latest Date

    Posted 08-19-2021 07:45

    Good Day,

    I need some advise on creating a formula date field that can display the latest date from several date fields.
    The formula I tried to use was this one below, It works for any dates in the past, but not for the future. Is there a better formula I can use to get the latest date?

    Max(
    If(Date Field 1] <= Today(), [Date Field 1]),
    If([Date Field 2] <= Today(), [Date Field 2])
    )

    Kind Regards,



    ------------------------------
    Lindy Austin
    ------------------------------


  • 2.  RE: Working out the Latest Date

    Posted 08-19-2021 07:49
    Maybe you are just over complicating it.

    try thus

    Max([Date Field 1]),[Date Field 2])


    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Working out the Latest Date

    Posted 08-19-2021 07:54

    Hi

    Thank you for the help.

    I was definitely over complicating the formula, working perfectly now.