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
If you've had any luck manipulating Dates in some other way, I'd love to hear! Thanks for lending your brainpower 🙂
Does that work for the use case you have in mind?
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
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
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
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.