Formula field in rule engine to add current date
Can we add a formula field in rule engine to capture the rule date.
+4Hello 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!
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!
Scott Drost, Gainsight -- Principal Customer Success Architect
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.
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!
Is there any update on this?
Thanks!
+4Until 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.
We considered this item into development, The functionality will be available in one of the coming release.
+5+1 to this, it would be extremely valuable to have this as part of the product!
Enterprise Support Manager, Gainsight
+2Hi Jahnavi,
Can you explain a little bit more about the use case and how you would use the current date in the rule?
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
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
+1Hi 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!
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.
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.
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.