Skip to main content
Question

Im trying to create a formula that will show the days over due or highlight over due if a date is not filled in....

  • July 12, 2017
  • 0 replies
  • 48 views
Im trying to create a formula that will show the days over due if a date is not filled in. For my formula, I have a Date of Death field and a Date Petition was Filed. If it has been 30 days since the date of death and no date is put into the date petition is field, I want the task to show as overdue. Any Thoughts?
    This topic has been closed for replies.

    • JohnThomas
    • Quickbase Alumni
    • July 12, 2017
    Insert the below formula to the formula text field 

    If(IsNull([Date of Petition]) and ToDays(Today() - [Date  of Death]) >=30 , "Overdue"  )

    I hope this will solve your issue!!!
    • AngelaBowman
    • Author
    • Quickbase Alumni
    • July 12, 2017
    Perfect.  Thank you John.  If I wanted the text Overdue to be red and bold, where would I add the HTML into the formula?
    • JohnThomas
    • Quickbase Alumni
    • July 12, 2017
    If(IsNull([Date of Petition]) and ToDays(Today() - [Date  of Death]) >=30 ,  "<span style=\"color:#ff0707; font-weight:bold\">"&"OverDue"&"</span>" )

    Ensure that you made the html tags as allowed


    Is it fine? :) 
    • AngelaBowman
    • Author
    • Quickbase Alumni
    • July 12, 2017
    Thank you!  Works Perfect!
    Terms & ConditionsAccessibility statement