Forum Discussion

MattGill's avatar
MattGill
Qrew Trainee
6 years ago

Issue with creating a Text formula with dates

 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.