Report Builder and date manipulation
|
Id |
Summary |
Constraint Date |
|
123 |
This has expired |
01/01/2019 |
|
456 |
This is about to expire within 60 days |
12/05/2019 |
|
789 |
This item is in good shape |
05/05/2020 |
Using (), how can I get the report to show the below? It looks like Colors is for an exact match, and Calculated, not sure about. (Sorry, in the EDIT window, the expired work item Constraint is Red, the next one is Yellow. This forum may not support that, so I have edited this request)
|
Id |
Summary |
Constraint Date |
|
123 |
This has expired |
01/01/2019( Cell=red)
|
|
456 |
This is about to expire within 60 days |
12/05/2019 (Cell=yellow)
|
|
789 |
This item is in good shape |
05/05/2020 |
3 answers
DAYS($Work Item:Due Date$)-DAYS(CURRENT_DATE)
JRS 7.0 is delivering multi-attribute support and it will be much simpler to create such reports. We are also providing support to choose a function when creating a customer expression via RB UI, similar what is shown by Alex. You can see preview in JRS 7.0 RC1 N&N https://jazz.net/pub/new-noteworthy/jrs/7.0/7.0/index.html#6 or test it on jazz.net self-host env.