Skip to main content

Date Fields in Bionic Rule Formula

  • October 18, 2017
  • 6 replies
  • 15 views
joseph_siudzinski
Forum|alt.badge.img+2
I just came across a use case where it would be great to subtract one date from another in a bionic rule transformation task. We are to a point in our project where we can't add fields to objects and I need a 'Percent Complete' field for some CTAs. If I could do the formula in the rule, just like we can in MDA, this would be super helpful.
    Brent Krempges
    joseph_siudzinski
    devin_stevens

    6 replies

    tom_zoellner
    • tom_zoellner
    • Contributor ⭐️⭐️
    • October 18, 2017
    +1

    This is a use case I had to work-around for a prospect... would be much easier if we could create formula fields over dates.
    karl_rumelhart
    Forum|alt.badge.img+4
    Yes.  String and date formulas coming in Fall. 
    jitin_mehndiratta
    dan_ahrens
    Forum|alt.badge.img+2
    • dan_ahrens
    • Expert ⭐️⭐️⭐️
    • October 19, 2017
    Here's a list of the fields coming in the Fall release (thread here). 

    I'm pretty giddy about these coming to rules engine. Yet another way we are killing the need to use Excel!

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    Hi Dave, 

    For Fall release, following formula functions related to string and date will be available in transformation task of rules engine.

    1. ToUpperCase(d), 
    2. ToLowerCase(D), 
    3. Start of Week(), 
    4. End of Week(), 
    5. Start of Month(), 
    6. End of Month(). 
    7. Num of Days (Date - Date(Datetime)), 
    8. Date (DateTime), 
    9. Start of Calendar Quarter(), 
    10. End of Calendar Quarter()
    11. Concat (a,b,"whatever",...), 

    We plan to have additional functions like subtring, length, position etc. in the upcoming releases. 

    Regards,
    Jitin
    VP of Customer Success at Forcepoint
    jitin_mehndiratta
    devin_stevens
    srinivas_muthyam
    Just to update: "Num of Days" function we have changed to "Date diff( Date, Date, Unit)". This is for extensibility at later point of time. Currently we support one type of Unit(Days).
    jitin_mehndiratta
    sai_ram
    Forum|alt.badge.img+1
    • sai_ram
    • Expert ⭐️⭐️
    • November 30, 2017
    Hi , Happy to inform you that this is implemented and shipped in Fall release on 28th November, 2017. 
    Thanks for posting! Your feedback matters, please continue posting!
    You can find more details here
    R
    Forum|alt.badge.img
    • rakesh_lingala
    • Helper ⭐️⭐️⭐️
    • July 27, 2020

    Hello Everyone!

    The Add/Subtract Date Formula field in the Date Formulas of Transformation Tasks now accepts dynamic fields. Previously, this field accepted only static numeric values as input. With this v6.16 release, the number of days you add to or subtract from a date dynamically changes with the value of the selected field. 

    Also, Gainsight introduces new Number Formulas to the Formula Fields in Rules Engine. These enable you to perform powerful calculations in your Transformation Tasks while setting up a rule. 

    This feature is implemented in both SFDC & NXT versions.

    Thanks for posting!

    sai_ram
    Terms & ConditionsCookie settingsAccessibility statement