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
------------------------------
