Skip to main content
jahnavi
Contributor ⭐️⭐️⭐️⭐️⭐️
November 22, 2017

Formula field in rule engine to add current date

  • November 22, 2017
  • 11 replies
  • 87 views
Can we add a formula field in rule engine to capture the rule date.

    11 replies

    sdrostgainsightcom
    Gainsight Employee ⭐️⭐️⭐️
    December 14, 2017
    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!
    Scott Drost, Gainsight -- Principal Customer Success Architect
    srinivas_muthyam
    Helper ⭐️
    December 14, 2017
    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. 
    jeremy_curry
    Helper ⭐️⭐️
    May 11, 2018
    Hi Srinivas,

    Is there any update on this?

    Thanks!
    pele
    Helper ⭐️⭐️⭐️
    May 11, 2018
    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. 
    srinivas_muthyam
    Helper ⭐️
    June 19, 2018
    Hi Jeremy,

    We considered this item into development, The functionality will be available in one of the coming release. 
    tom_gerth
    Gainsight Employee ⭐️⭐️
    June 25, 2018
    +1 to this, it would be extremely valuable to have this as part of the product!
    Enterprise Support Manager, Gainsight
    dan_ahrens
    Expert ⭐️⭐️⭐️
    July 23, 2018
    Hi Jahnavi,

    Can you explain a little bit more about the use case and how you would use the current date in the rule?
    VP of Customer Success at Forcepoint
    prabhat
    Contributor ⭐️⭐️
    September 12, 2018
    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
    sai_ram
    Expert ⭐️⭐️
    October 16, 2018
    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!​
    jahnavi
    jahnaviAuthor
    Contributor ⭐️⭐️⭐️⭐️⭐️
    October 17, 2018
    Is this rule run date a date time or just date ?