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]))
Thank you for the help.
I was definitely over complicating the formula, working perfectly now.