I am trying to set an alert that lets me know that it's 30 days or less until the [Effective_Date] ends. I cannot seem to get the formula or formula type to work.
If ([Effective_Date]-Today()<=30,"Renew","Good") Any assistance would be greatly appreciated.