Working out the Latest Date

Question

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] &lt;= Today(), [Date Field 1]),If([Date Field 2] &lt;= Today(), [Date Field 2]))

Kind Regards,------------------------------Lindy Austin------------------------------

markshnier__you · Answer

Maybe you are just over complicating it.try thusMax([Date Field 1]),[Date Field 2])------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

lindyaustin · Answer

Hi
Thank you for the help.
I was definitely over complicating the formula, working perfectly now.

Forum Discussion

Working out the Latest Date

2 Replies