Solved

Getting false results to DATETIME_DIFF formula

Hi,

I try to calculate the time duration between two date fields with DATETIME_DIFF formula, but doesn’t work at all. It shows totally false results.

Here it is:

This is the formula I use:

This is the formatting for duration:

Any idea what I should do?

Best answer by Andonisz_Haroni

Hi there,

Thanks for your responses!

The solutions was.

One time field was in GMT while the other wasn’t. So I turned off this setting on both.

Furthermore the formula has been set to Duration and h:mm:ss format.

Now it works.

+18

Hi @Andonisz_Haronisz - it is because you have the result as a duration when it should be an integer. From the formula docs:

Note : The DATETIME_DIFF() formula will return whole integers for any unit specifier.

+29