My formula for DATETIME_DIFF is not returning expected results but I can’t figure out what it’s calculating.
The first should return a difference of 1:48, the second of 0:20.
When I set the function without any specifiers, I get 4:12 and 5:40, and wh...
Oh! you were on track with the time zone setting … I can get the correct calculation when I turn off the “use same time zone for all users” - but the weird part is, it only works if I turn it off for just one of the start/end times - if I do it for b...
No - that is still giving me weird numbers. Also, look what happens when I set the start and end times the same - I end up with a 6:00 baseline … when obsv should be zero. Something is weird - a setting somewhere?
Nope … it’s giving me the same as with no specifiers:
The numbers are clearly related (i.e. 4:12 somehow relates to 1:48 and 5:40 relates to 20) but even the differences between my result and what I am expecting aren’t consistent (2:30 and 4:20).
