Forum Discussion

AngelaBowman's avatar
AngelaBowman
Qrew Cadet
8 years ago

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

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?
Formulas and functions
  • JohnThomas's avatar
    JohnThomas
    Qrew Cadet
    8 years ago
    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's avatar
    AngelaBowman
    Qrew Cadet
    8 years ago
    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's avatar
    JohnThomas
    Qrew Cadet
    8 years ago
    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? :)