If Date Field is Null Turn Row Red

Question

Hi,I have a report where I would like a row to turn red if the task has not been completed within 7 days of the assigned date. However, I am receiving an error. Any suggestions will be greatly appreciated!!
If [Completion Date] is Null
And is Greater than 7 days of the [Assignment Date and Time]
Turn row #F60612
If([Completion Date]="null" and [Assignment Date and Time] >  7 ,"#F60612")------------------------------Thank you,Clarice Dennison------------------------------

MarkShnierYou · Answer

Try thisIF(IsNull([Completion Date])andToDate([Assignment Date and Time]) - Days(7) >= Today(), "#F60612")//I'm assuming that the Completion Date is a Date field type and the other field is a Date / Time field type.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Sign up

Login to the community