I have requirement to calculate the time difference between 2 dates
Based on that I have to display the result in hours and mins
Is there any OOTB function available
I have tried DateTime difference but we can get either days or minutes or hours in that.
***Edited by Moderator: Pallavi to update platform capability tags***
Do something like this can be implemented for reports?
I noticed we already have the function pxConvertTimeUnits to convert from seconds to minutes, or from minutes to hours, etc. But what if we want to convert from seconds to hours-minutes? example: 3660 seconds will result in 1 hour, 1 min. Or maybe display minutes if the hour hasn't been completed, like displaying 30 minutes instead of 0.5 hours.
There is no OOTB function alias that will do this specific calculation and formatting. It would have to be implemented as a custom function alias. Note that function aliases can be nested (one function alias can call another) so this can probably be done mostly by calling OOTB FAs from the custom FA.