Discussions

Expand all | Collapse all

Issue with creating a Text formula with dates

  • 1.  Issue with creating a Text formula with dates

    Posted 02-22-2019 20:36
     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.


  • 2.  RE: Issue with creating a Text formula with dates

    Posted 02-22-2019 20:43
     If (ToDays([Effective_Date]-Today())<=30,true,false)






  • 3.  RE: Issue with creating a Text formula with dates

    Posted 02-22-2019 21:15
    That worked! Thank you!!