Can anyone tell me how to calculate the age of an issue when it's closed? The native Age field continues to calculate after an issue has been closed. I want to know the time elapsed between entering an issue and closing it. | Community
Skip to main content
MelissaDa5
Level 3
April 21, 2020
Question

Can anyone tell me how to calculate the age of an issue when it's closed? The native Age field continues to calculate after an issue has been closed. I want to know the time elapsed between entering an issue and closing it.

  • April 21, 2020
  • 1 reply
  • 563 views
No text available
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Adobe Employee
April 22, 2020

Hi Melissa,

You have a few options.

#1) You can set up a report with a column using text mode, and a valueexpreesion similar to:

valueexpression=DATEDIFF({entryDate},$$TODAY)

OR

#2) You can create a calculated field that is applied to each issue you want the data on, with a similar expression as above, slightly modified: DATEDIFF(Entry Date,$$TODAY)

One thing to note if you go the field route is that custom data is not calculated every time you view it, only when it's changed, or another custom field from the same form on the same object it's on is changed.

Ex: If I update a different custom field on the same form on my issue, it'll update all the custom data on that field on that issue.

Good luck!