Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Getting false results to DATETIME_DIFF formula

Topic Labels: Formulas
Solved
Jump to Solution
249 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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:

airtable1

This is the formula I use:

airtable2

This is the formatting for duration:

airtable3

Any idea what I should do?

1 Solution

Accepted Solutions

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.

See Solution in Thread

3 Replies 3

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.

Try using the unit specifier ‘seconds’ instead of ‘minutes’ in your formula.

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.