Decimals using datetime formula

[Pablo]

Hi!

We have the following formula to calculate the number of days it takes to resolve each ticket:

resolveDays = datetime\diff(resolveDate, createdAt, 'days');

It works perfect. However, we would like to calculate this value with decimals to be more precise (example: 0.6 days, 1.5 days...).

Can you help us modifying this formula to obtain decimal days?

Thanks a lot!

[Maximus]

Hello,
You can try something like this:

resolveDays = number\format(datetime\diff(resolveDate, createdAt, 'hours') / 24, 1);

[Pablo]

Yes, yes, yes! It works PERFECT! Thanks a lot Maximus

Merry Christmas!

[Zebrass]

Hello,
You can try something like this: telldunkin

resolveDays = number\format(datetime\diff(resolveDate, createdAt, 'hours') / 24, 1);

Exactly what I needed! You just saved me several hours. Thanks!