Skip to main content
balajibv
balajibv
Contributor ⭐️⭐️⭐️
Aug 30, 2024 3:49 PM UTC
Question

Formula Fied - Date Difference - Hours

Im creating a report to see how many hours it takes for the Gong-Gainsight integration to create timeline entries since the activity happened.

In the interval, I cant find Hours. Also the resultant value is not decimal either.

What is the reasoning for not having Hours, Minutes, Seconds when literally there is Milliseconds? Maybe I should submit that as an Idea.

Also I noticed, it ignores the “Time” portion and simply shows the “Day” difference. However same formula shows milliseconds in difference where it considers the time portion. Its confusing how same formula behaves differently based on Interval. This is incorrect as the interval should only affect the FRACTION of the result, not the behaviour.
 

 

    2 replies

    balajibv
    balajibvAuthor
    Contributor ⭐️⭐️⭐️
    Aug 30, 2024 5:06 PM UTC

    So, we did a workaround by dividing the milliseconds with 3600000 and got the hours!! But that formula field is inconsistent.
     

     

    Translate
    ~BV~
      romihache
      romihache
      VIP ⭐️⭐️⭐️⭐️⭐️
      Oct 18, 2024 12:14 PM UTC

      It makes no sense that is missing, and is inconsistent with the Date Diff formula in Rules Engine where the hour unit exists☹️
      The same is true the other way around, the formula in rules engine is missing all units >Day. Both formulas should have all the options… #parity 


       

      Translate
      Continuous improvement is better than delayed perfection
        Terms & ConditionsAccessibility statement