Jun 07, 2021 06:16 AM
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?
Solved! Go to Solution.
Jun 07, 2021 09:04 PM
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.
Jun 07, 2021 01:28 PM
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.
Jun 07, 2021 03:44 PM
Try using the unit specifier ‘seconds’ instead of ‘minutes’ in your formula.
Jun 07, 2021 09:04 PM
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.