Workaround Available

Expand date diff bionic rules formula

  • 27 March 2019
  • 2 replies
  • 51 views

Userlevel 7
Badge +1
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.

rakesh_lingala 1 year ago

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!

View original

2 replies

Userlevel 7
Badge
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.

Userlevel 6
Badge

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!

Reply