Skip to main content
New Idea

Add 90 Days to Contract Start Date

Related products:None
kendra_mcclanahan
jean.nairon
link_black
angela_domenichelli
lauren_wood
+119
  • kendra_mcclanahan
    kendra_mcclanahan
  • jean.nairon
    jean.nairon
  • link_black
    link_black
  • angela_domenichelli
    angela_domenichelli
  • lauren_wood
    lauren_wood
  • colleen_fleming
    colleen_fleming
  • zach_davis
    zach_davis
  • matthew_lind
    matthew_lind
  • nick_morris
    nick_morris
  • jesus_mejia
    jesus_mejia
  • cmultanen
    cmultanen
  • diane_morneau
    diane_morneau
  • samantha_braastad
    samantha_braastad
  • heather_hansen
    heather_hansen
  • kelly
    kelly
  • anna_whitehouse
    anna_whitehouse
  • candacemarie_mitcham
    candacemarie_mitcham
  • spencer_engel
    spencer_engel
  • aaron_blum
    aaron_blum
  • tracy_streetman
    tracy_streetman
  • whitney
    whitney
  • kristen_bailey
    kristen_bailey
  • kristen_debrosky
    kristen_debrosky
  • holly_gilleo
    holly_gilleo
  • vicki_chase
    vicki_chase
  • kyle_howard
    kyle_howard
  • margaret_cates
    margaret_cates
  • perry_rogers_10158d
    perry_rogers_10158d
  • ablnsj
    ablnsj
  • jennifer_richard
    jennifer_richard
  • emily_smith
    emily_smith
  • liam_nicholls
    liam_nicholls
  • anna_frenette
    anna_frenette
  • ana_g
  • carolyn_dibuono
    carolyn_dibuono
  • chris_h
    chris_h
  • jasminebondc
  • ml2019
    ml2019
  • gunjanm
    gunjanm
  • pmccrudden
    pmccrudden
  • andreammelde
    andreammelde
  • michellebisping
  • GarethR
    GarethR
  • bdudro
  • ewinglel
    ewinglel
  • rishi
    rishi
  • tammy_c
  • darshana.shah
    darshana.shah
  • Ester.Memoli
    Ester.Memoli
  • CurtisValentine
    CurtisValentine
  • waynedilworth
    waynedilworth
  • nicterry
  • haleylund
    haleylund
  • stuv
  • akaprielian24
  • abeck0625
    abeck0625
  • bradley
    bradley
  • derrick.harper
  • Andy_Lewis
  • justynharvey2021
  • Christina P
    Christina P
  • tmorgan
    tmorgan
  • Wayne
  • sarahmiracle
    sarahmiracle
  • romihache
    romihache
  • mandy.j
  • john.cowles
    john.cowles
  • sgeorge
    sgeorge
  • Chris Mudd
  • Paulina
    Paulina
  • alizee
    alizee
  • Molly.McQ
    Molly.McQ
  • jrich
    jrich
  • Steph Costa
  • Elana Cipin
  • Sasi Supritha
    Sasi Supritha
  • KristyGarrison
    KristyGarrison
  • georgesmolkin
    georgesmolkin
  • zbaumayr
  • candace
  • Jessue
  • Kledger
  • Aurelian
  • chad.aiken
    chad.aiken
  • chtown12
    chtown12
  • erikmoti
  • Claudiu Neagu
  • Var00
  • abomb119
  • amalialamba
  • Anna
    Anna
  • fiona.au
  • jrzlawrence
    jrzlawrence
  • jdeutschmann
  • jenlpro
    jenlpro
  • simonechen
    simonechen
  • rachana.shastry
  • tricia
  • dayn.johnson
    dayn.johnson
  • Stuart
    Stuart
  • ZainT
  • zdsiegert
    zdsiegert
  • DavidSilva
  • mobrien14
    mobrien14
  • clmonteleone
  • ccrawford1062
  • alinall
  • max_lane
    max_lane
  • Karo
    Karo
  • amasica1217
    amasica1217
  • ryan_lehman
  • Tejashwini Golla
    Tejashwini Golla
  • rgupta91
  • ajprince
    ajprince
  • Kornelija_V
  • dcassidy
    dcassidy
  • CristianaF
    CristianaF
  • kim_stone
    kim_stone
  • Al M
  • kallis
  • Adam.LaFreniere
  • kristineo
  • Catyguerrant
  • ktheriault

seth
  • Gainsight Employee ⭐️⭐️⭐️
  • 550 replies
Has anyone had success using Gainsight to add or subtract days from a date field?

I'm trying to figure out the number of users for a customer in the first 90 days of their contract. (I need to run a comparison against the number of users in the trailing 90 days from today.)

I can grab the contract start date from Opportunity, and I can join it to the Google Analytics MDA data in a Bionic Rule. Then I could limit the Google Analytics data to "Google Analytics Date >= Contract Start AND Google Analytics Date < 90 Days After Contract Start"/

However, I can't figure out a way to add 90 days to the contract start date.
  • Bionic Rule > Transformation Task > +Formula Field: Formula fields don't act on Date fields, so I can't just simply add 90 Days to the Date
  • Rule "Filters": I can say "This field is less/greater than another field", and I can "Add/Subtract N Days from Rule Date", but I can't "Add/Subtract N Days from Date Field"
  • MDA Google Analytics Data: I could add a formula field for "This Pageview's Date plus 90 days", except that MDA object isn't editable
The only thing I can think of is adding a Salesforce Formula Field to the Opportunity, to add 90 Days to the Contract Start Date. However our Salesforce instance is busy with extra fields, so I'd rather not add yet another one unless absolutely necessary.

If you've had any luck manipulating Dates in some other way, I'd love to hear! Thanks for lending your brainpower 🙂

seth
Forum|alt.badge.img+7
  • Gainsight Employee ⭐️⭐️⭐️
  • June 15, 2017
Oh man, I so want to get this to work -- it's too pretty to give up on!


karl_rumelhart
Forum|alt.badge.img+4
We obviously need to get formulas on date fields working.  This rule really is insanely cool!  Here is a wicked hack to try: build a table with two columns: first with a list of date vales and a second with those dates plus 90 days. (Could in Excel and then import as CSV or something.)  Then join on the date filed with this table and get a new column with what you want.  

seth
Forum|alt.badge.img+7
  • Gainsight Employee ⭐️⭐️⭐️
  • June 16, 2017
OH HO! Karl, master hacker extraordinaire! Can't wait to get that set up -- gonna need to print this Rule out and get it framed.

karl_rumelhart
Forum|alt.badge.img+4
Let me know if it works!  

mindy
Forum|alt.badge.img+1
  • Helper ⭐️
  • January 23, 2019
Hey @Seth - have you figured out a better way to do this since you posted? I'm running into the exact same thing and would love to hear that you have a solution


seth
Forum|alt.badge.img+7
  • Gainsight Employee ⭐️⭐️⭐️
  • January 23, 2019
Hi Mindy! Yes indeed. The feature that's come out since this post, which would have helped me, is the Date Diff function: https://support.gainsight.com/View_More_Categories/GainsightNXT/03Rules_Engine/02Admin_Guides/05Formula_Fields_in_Rules_Engine#Usage_of_Date_Formulas

Does that work for the use case you have in mind?


mindy
Forum|alt.badge.img+1
  • Helper ⭐️
  • January 23, 2019
Hmm, unfortunately not going to work for my use case. I'm trying to send an auto-renewal notice email and wanted to include the new subscription time frame ("renewal date" - "renewal date + 1 year"). I felt confident that I could add 365 to the renewal date in the bionic rules but when I dug in couldn't actually find a way to do it. Oh well - not the end of the world, but would have been nice. Thanks for the quick response!


seth
Forum|alt.badge.img+7
  • Gainsight Employee ⭐️⭐️⭐️
  • January 24, 2019
Oof, sorry to hear it! Karl's workaround seems like the best option, then. In the face of a subscription timeframe, though, I've seen that stamped into a custom date field in Salesforce anyways, so that the next renewal date is always extremely accessible, and can be edited for special cases like extensions.


joseph_siudzinski
Forum|alt.badge.img+2
We still really need the ability to add/subtract a number from a date field to return a date. The new bionic formulas are great, but this is a simple and common use case that is missing.


jitin_mehndiratta
Hi All,

We now can subtract/Add no. of days/weeks to a particular date.

Add/ Subtract Date formula is now available in Transformation task of Rules engine.

Regards,

Jitin


Forum|alt.badge.img
Hi All,

Sorry to bump this thread. I am trying to add a number to a particular date field.

I know we now have the Add/Subtract Date Formula, however this only allows us to assign an actual number to the addition/subtraction. But what if my number was not fixed but was rather stored in a numeric field (Assigned Time in Hours, in my example)?

For example:

Created Date + Assigned Time in Hours = Assigned Date

(07/28/19) + 48h = (07/30/19)

Is this possible?

Thanks,

Ricardo


kate_green
Forum|alt.badge.img
  • Helper ⭐️⭐️
  • July 30, 2019
Agree!


  • Contributor ⭐️⭐️⭐️
  • August 8, 2019
Hi Ricardo,

From what I tested, there's currently no way of having the add/subtract value dynamic.

Maybe that will be the case in a future version.

Thanks,

Lucian


phani_kumar
Forum|alt.badge.img+3
  • Gainsight Employee ⭐️⭐️
  • April 21, 2020
ricardosantos wrote:

Hi All,

Sorry to bump this thread. I am trying to add a number to a particular date field.

I know we now have the Add/Subtract Date Formula, however this only allows us to assign an actual number to the addition/subtraction. But what if my number was not fixed but was rather stored in a numeric field (Assigned Time in Hours, in my example)?

For example:

Created Date + Assigned Time in Hours = Assigned Date

(07/28/19) + 48h = (07/30/19)

Is this possible?

Thanks,

Ricardo
 

+1. Recently I also faced this same use case.

Providing an option to add the Numeric field to the Date field was really a good idea.



Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings