Skip to main content
christopher_sanderson
christopher_sanderson
Helper ⭐️⭐️
March 27, 2019

Expand date diff bionic rules formula

  • March 27, 2019
  • 2 replies
  • 95 views
The formula field works well, but if I need to take today's date and subtract a different date field, I have to do a transform task to put in the Rule Date formula field, then do a 2nd transform task to make the magic happen. I take an existing date field and subtract today, I don't need the extra transformation task.

Ask: allow me to use Rule Date in either slot of the date diff formula.

      2 replies

      kate_green
      kate_green
      Helper ⭐️⭐️
      March 27, 2019
      I agree that it was confusing that I couldn't use Rule Date in the first slot of the Date Diff formula field without having to add it in a previous transformation step.

      I did end up using it in the second slot instead.

      R
      rakesh_lingala
      Helper ⭐️⭐️⭐️
      July 27, 2020

      Hello Everyone!

      The Add/Subtract Date Formula field in the Date Formulas of Transformation Tasks now accepts dynamic fields. Previously, this field accepted only static numeric values as input. With this v6.16 release, the number of days you add to or subtract from a date dynamically changes with the value of the selected field. 

      Also, Gainsight introduces new Number Formulas to the Formula Fields in Rules Engine. These enable you to perform powerful calculations in your Transformation Tasks while setting up a rule. 

      This feature is implemented in both SFDC & NXT versions.

      Thanks for posting!

        Terms & ConditionsAccessibility statement