Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Reports - Need text mode help!

Avatar

Level 3

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

Topics help categorize Community content and increase your ability to discover relevant content.

0 Replies

Avatar

Level 10

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.