topic Re: formatDuration() has a maximum? in Dashboards & Analytics Discussions

formatDuration() has a maximum?

marcpaige — Tue, 23 May 2023 20:48:16 GMT

One of my team discovered that formatDuration() has a maximum input value of 2147483 resulting in an output of "24d 20:31:23". Is this a bug?

Re: formatDuration() has a maximum?

marcpaige — Tue, 23 May 2023 20:55:23 GMT

We are still testing. It seems there is an error on the testing side with our data.

Re: formatDuration() has a maximum?

marcpaige — Wed, 24 May 2023 17:23:34 GMT

So, it turns out that the issue was with using int() vs. long() in the internal conversion of a millisecond calculation.

The documentation is not clear for formatDuration(). It states that it takes an int value. It should also state that it can take a long value as using that conversion function results in the proper result.

Re: formatDuration() has a maximum?

JoeM — Wed, 24 May 2023 17:28:46 GMT

@marcpaige we can make that update - just need to clarify with you here first. Are you saying that you found it to take a long() and it did generate results albeit them incorrect?

Re: formatDuration() has a maximum?

marcpaige — Wed, 24 May 2023 18:33:51 GMT

Using formatDuration(long((calculated double value)) returns a correct result.

When using the int() conversion function it returns the max value of INT format.

Re: formatDuration() has a maximum?

marcpaige — Wed, 24 May 2023 18:47:57 GMT

The following shows the situation.