


I have a report that shows me the planned completion date of an issue (in 1 column) and the resolving task planned completion date in another column.
We use this report to compare the 2 dates and will adjust them accordingly.
Can someone please provide me the text to format the Issue Planned Completion Date as red and bold if it is not equal to the resolving task planned completion date?
TIA!
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Sign in to like this content
Total Likes
Hi Meghan,
The below text mode should do it on an issue report.
displayname=
linkedname=direct
namekey=plannedCompletionDate
querysort=plannedCompletionDate
styledef.case.0.comparison.icon=false
styledef.case.0.comparison.leftmethod=plannedCompletionDate
styledef.case.0.comparison.lefttext=plannedCompletionDate
styledef.case.0.comparison.operator=ne
styledef.case.0.comparison.operatortype=date
styledef.case.0.comparison.rightmethod=resolveTask:plannedCompletionDate
styledef.case.0.comparison.righttext=resolveTask:plannedCompletionDate
styledef.case.0.comparison.trueproperty.0.name=fontstyle
styledef.case.0.comparison.trueproperty.0.value=bold
styledef.case.0.comparison.trueproperty.1.name=textcolor
styledef.case.0.comparison.trueproperty.1.value=d30519
styledef.case.0.comparison.truetext=
textmode=true
valuefield=plannedCompletionDate
valueformat=atDate
One thing to point out is that the comparison between the two dates will also take into consideration the time. So if the planned completion date of the issue is 12th April at 9:00am, and the planned completion date of the task is 12th April at 9:01am, this will still highlight in red.
Best Regards,
Rich.