Forum Discussion

LindyAustin's avatar
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?

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

Kind Regards,

Lindy Austin

2 Replies

  • Maybe you are just over complicating it.

    try thus

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

    Mark Shnier (YQC)
    • LindyAustin's avatar
      Qrew Member


      Thank you for the help.

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