I want to create a date formula that does the following:
Date field 1= Last service date
Date field 2 = Next service date (this must be 1 year in the future) and, if the last service has been more than 365 days ago, then date field 2 must be equal to today. I tried this formula, but it is giving me a syntax error.
I'm not sure how to reference field ID's in a formula?
=IF([Last service date]-today()>365],Today(),[Last service date]+365)