Skip to main content
steve_davis
steve_davis
Gainsight Employee ⭐️⭐️
May 25, 2017 8:41 PM UTC

Formula Field In MDA Subtracting 2 Date/Time Fields

I have a customer who would like to do a calculated field in an MDA object where they subtract date/time 1 from date/time2 and calculate duration. Is this something we have road mapped?

Steve 

      2 replies

      dan_ahrens
      dan_ahrens
      Expert ⭐️⭐️⭐️
      Dec 26, 2017 2:11 PM UTC
      Hey Steve, I know this thread is a few months old, but it popped up in a search when I was looking for something similar so I wanted to update that in the Fall 2017 release we now have the functionality in the rules engine to calculate the difference between two dates. 

      More info here: https://support.gainsight.com/Product_Documentation/Rules_Engine/Admin_Configuration/Formula_Builder...
      Translate
      VP of Customer Success at Forcepoint
      sai_ram
      sai_ram
      Expert ⭐️⭐️
      May 22, 2019 4:51 PM UTC
      Hi Steve, Here is a good news about implementation of Formula fields in MDA, hope this solves your use-case. 

      With this release, Gainsight now allows you to create calculated fields by using String and Date functions. You can find these functions on the Create Calculated Field window.

      You can create a calculated field by using the existing fields in that object, as arguments of the function. Apart from the existing fields, you can also use other applicable formula functions as arguments while building a formula field.

      For more information please follow this article.

      Thanks for posting!

      Translate
      Terms & ConditionsAccessibility statement