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
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!!!