Issue with creating a Text formula with dates

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
 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.
Photo of Matt Gill

Matt Gill

  • 154 Points 100 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of wwdmr

wwdmr

  • 246 Points 100 badge 2x thumb
 If (ToDays([Effective_Date]-Today())<=30,true,false)




Photo of Matt Gill

Matt Gill

  • 154 Points 100 badge 2x thumb
That worked! Thank you!!