Forum Discussion

LindyAustin's avatar
LindyAustin
Qrew Member
3 years ago

Working out the Latest Date

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
------------------------------
Formulas and functions

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    3 years ago
    Maybe you are just over complicating it.

    try thus

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


    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • LindyAustin's avatar
      LindyAustin
      Qrew Member
      3 years ago

      Hi

      Thank you for the help.

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