Can I calculate days since a custom date time field?

[Nathan Robertson]

Hello -

I have a custom field "End Time" which is a date/time field. I'm trying to add a custom value to a rich filter that would allow me to calculate the time difference between "End Time" and now.

To be more specific I want to be able to have a column in my table that for each row will calculate the difference between "End Time" and now and show it as a value in the column. Is that possible in a rich filter?

[Hannes Obweger - JXL for Jira]

Hi @Nathan Robertson

in native Jira, I can really only think of a Jira Automation-based solution, where you'd have to run a rule regularly (e.g., every day, or every hour, depending on how exact you need the result to be) to do the math, and write the result into a custom field. You could then add the custom field to your filter result. It's clearly not ideal, since you could end up with a very large amount of rule executions.

Alternatively, if you're open to solutions from the Atlassian Marketplace, you'll have more options. I'll add more information below.

Hope this helps,

Best,

Hannes

[Hannes Obweger - JXL for Jira]

... and to expand on my last point: If you're open to solutions from the Atlassian Marketplace, your use case would be easy to solve in the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a long list of so-called smart columns that aren’t natively available, including the time to/since your date and date/time fields. 

This is how it looks in action:

I'm using the time since status changed column here, but it would look the same for a time since/to end date column.

As you can see above, you can easily sort and filter by your smart columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

This all just works - there's no scripting or automation whatsoever required.

Any questions just let me know!