It's all about the answers!

Ask a question

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)?

Janet Charbonneau (831033) | asked Dec 29 '17, 12:07 p.m.
edited Dec 29 '17, 12:07 p.m.

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 =, 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, 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?


Ralph Schoon commented 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.

One answer

permanent link
Kenji Sarai (96029) | answered Jan 03 '18, 6:53 p.m.

Hi Janet,

Assuming you are using data warehouse for JRS, you can modify the SQL query directly in Advanced tab. Use timestampdiff (DB2) or datadiff (SQL Server) function to calculate the number of days. If you have a problem, engage the database specialist.

Your answer

Register or to post your answer.