Skip to main content

Horizon Rules: Tokenize a number for add/subtract date formulas

  • October 4, 2023
  • 1 reply
  • 12 views

B.Abrahams
Forum|alt.badge.img+3

 

This is applicable when adding a Formula to a transform through Rules Engine, the Add/Subtract date does not let you select from available number fields in the “value” drop down list. This was a feature in Bionic rules but somehow got lost with the release of Horizon rules.

 

This is also not available in other areas such as Data Designer, Report Builder, and Data Management. 

 

The use case I have is we have a “Renewal Term” field that defines the renewal term (12, 24, 36, ect.), I would like to add those months to the Renewal Date and update it through an Company update action when the renewal date is less than the span of the run date.

1 reply

B.Abrahams
Forum|alt.badge.img+3
  • Author
  • Contributor ⭐️⭐️
  • October 4, 2023

Here is what it looks like in Bionic Rules, this screenshot is sourced from the “Formula Fields in Rules Engine” Admin Guide.