Discussions

Expand all | Collapse all

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

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

    Posted 07-12-2017 11:02
    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?


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

    Posted 07-12-2017 11:34
    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!!!


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

    Posted 07-12-2017 11:53
    Perfect.  Thank you John.  If I wanted the text Overdue to be red and bold, where would I add the HTML into the formula?


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

    Posted 07-12-2017 11:56
    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? :) 


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

    Posted 07-12-2017 14:50
    Thank you!  Works Perfect!