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 ...
Formulas and functions
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? :)