Thank you for sharing this idea! Have you tried to experiment if it might be possible to use several of these functions to get the results?
I thought about it but when I started formulating, I realized one would need to understand how these values are calculated so for example (daysBetween(#start_date)*24)[hours] : (minutesBetween(#startDate) : (minutesBetween(#start_date)*60)[seconds]… but I’m not sure this will calculate the actual duration.
If you really need to get these results then I think you can use postgresql SQL scripts to make these calculations.
Please feel free to create a Jira feature request on jira.dhis2.org
We don’t want ‘totalTimeinHours’:‘totalTimeinMinutes’:‘totalTimeinSeconds’ … and if that’s the result that we’re getting then that’s not what we are looking for! (:
Thank you for a good tip but the issue is that the daysBetween function rounds up or down the number of days, and this won’t calculate the exact duration between two dates.
I have created a Jira feature request and hopefully someone will work on it. Thank you
Thank you! I added CoP to the labels and added a comment to this topic page. I also tagged @Jim_Grace there too! (Jira feature request issue: [DHIS2-12680] - Jira)