Is there a way to run a report that will show a calculated value for number of days until the expiration date (ie. the difference between the current date and the expiration date)?
I am working on a license management project in RTC and I would like to show the number of days before a license expires. I wrote a calculated value script that will calculate the number of days between the current date and the expiration date of our licenses using "var day = dojo.date.difference(currDate, expDate, "day");". The script works fine to update the "Expires in" attribute with the number of days until the license expires; however, I found that this attribute will not update daily, so it only gets updated to the correct value when you change and save the work item.
After searching on jazz.net, it appears that the best way to accomplish this is to run a report, but I am not able to figure out how to do that. I have been able to run a query that shows the licenses with an expiration date that is within 6 months. In that query, I can show the expiration date attribute. However, I would really like to have a numeric value that states the number of days before the license expires. I was hoping that there was a way to do this in JRS, but have not found a solution. We are currently running version 6.0.3.
Is there any way to run a report that will show me the number of days until the expiration date?
Thanks!
Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jan 03 '18, 5:26 a.m.I would assume the correct question is rather how to create a calculated column in a report to show that value. I don't know, but I would suggest you reword the subject and the question itself t reflect that.