I tried using the first example:
iif([StipDate]>iif([Vacate]>[LeaseSigned],[Vacate],[LeaseSigned]),[StipDate],iif([Vacate]>[LeaseSigned],[Vacate]))
and I get an error about invalid syntax.
I have never used a VBA function in a query. How do you do that? I also don't understand the function...