Skip to main content
Question

Issue with creating a Text formula with dates

  • February 23, 2019
  • 0 replies
  • 35 views
 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.
    This topic has been closed for replies.

    • WladimirLlanos
    • Quickbase Alumni
    • February 23, 2019
     If (ToDays([Effective_Date]-Today())<=30,true,false)




    Terms & ConditionsAccessibility statement