Skip to main content
jahnavi
Contributor ⭐️⭐️⭐️⭐️⭐️
Nov 22, 2017 9:14 PM UTC

Formula field in rule engine to add current date

Can we add a formula field in rule engine to capture the rule date.

    11 replies

    sdrostgainsightcom
    Gainsight Employee ⭐️⭐️⭐️
    Dec 14, 2017 4:15 AM UTC
    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!
    Translate
    Scott Drost, Gainsight -- Principal Customer Success Architect
    srinivas_muthyam
    Helper ⭐️
    Dec 14, 2017 5:31 AM UTC
    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. 
    Translate
    jeremy_curry
    Helper ⭐️⭐️
    May 11, 2018 1:09 PM UTC
    Hi Srinivas,

    Is there any update on this?

    Thanks!
    Translate
    pele
    Helper ⭐️⭐️⭐️
    May 11, 2018 10:26 PM UTC
    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. 
    Translate
    srinivas_muthyam
    Helper ⭐️
    Jun 19, 2018 10:48 AM UTC
    Hi Jeremy,

    We considered this item into development, The functionality will be available in one of the coming release. 
    Translate
    tom_gerth
    Gainsight Employee ⭐️⭐️
    Jun 25, 2018 6:18 PM UTC
    +1 to this, it would be extremely valuable to have this as part of the product!
    Translate
    Enterprise Support Manager, Gainsight
    dan_ahrens
    Expert ⭐️⭐️⭐️
    Jul 23, 2018 10:52 PM UTC
    Hi Jahnavi,

    Can you explain a little bit more about the use case and how you would use the current date in the rule?
    Translate
    VP of Customer Success at Forcepoint
    prabhat
    Contributor ⭐️⭐️
    Sep 12, 2018 10:37 AM UTC
    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
    Translate
    sai_ram
    Expert ⭐️⭐️
    Oct 16, 2018 4:00 PM UTC
    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!​
    Translate
    jahnavi
    jahnaviAuthor
    Contributor ⭐️⭐️⭐️⭐️⭐️
    Oct 17, 2018 1:59 PM UTC
    Is this rule run date a date time or just date ?
    Translate