Skip to main content
Can we add a formula field in rule engine to capture the rule date.
Hello Jahnavi - 



This request has come up multiple times from Gainsight Admins, and it's also being discussed on an internal thread at the moment.



Wanted to let you know it's on the 'under consideration' list by product, and the Professional Services group here at Gainsight is voting it up too, so hopefully we'll hear back soon on plans to add the functionality!
Hi Jahnavi and Scott,



We will definitely keep this as an item to be added sooner. We will discuss internally and see the possibilities of adding it. 
Hi Srinivas,



Is there any update on this?



Thanks!
Until this is possible in rules, you could add a formula field to the customer info object in Salesforce that reads TODAY(). This has helped me out quite a bit in calculating DateDiffs in different rules. 
Hi Jeremy,



We considered this item into development, The functionality will be available in one of the coming release. 
+1 to this, it would be extremely valuable to have this as part of the product!
Hi Jahnavi,



Can you explain a little bit more about the use case and how you would use the current date in the rule?
Hi All,



This feature is coming October release. you should be able to achieve following


  • Rule Date will be a new formula - help you get Rule Date as a show field.
  • Date Diff will support difference from a show field to Rule Date
Hi All, this is fixed and available in October release. 



A new function called Rule Date has been added to the Date Formulas. This function returns the Date on which the rule is being executed (Current date). This function does not accept any arguments. 



Please refer the release notes for more information.



Thanks for posting!​
Is this rule run date a date time or just date ?
Hi Jahnavi, the data type of this is DATE.



In case of manual execution, the UI asks you for "Rule Date". If you have given a past date in "Run Now" dialog, the formula will return that date.







In case of scheduled executions, typically Rule Date and the day when rule executed are typically same, yielding current date.

Reply


Terms & ConditionsCookie settings