Official comment
Triggers and Waits both have this capability in Automations (campaigns).
Comment actions
Post
Follow
Feature Request: Date Math based on a date in a [date field]
It would be so incredibly helpful if there was a way provided in a campaign to do math against a date field that contains a future date. Everything in the campaign logic currently appears to be based on today's date. Right now I can "increase 90 days from today" however it would be so awesome to be able to "increase 90 days from [expiration date]", where [expiration date] is a date field in a contact record.
I could be mistaken, however, it appears that math like this can be done already with a merge in an email "[date field] + 90 days". It would be awesome if the result of that math could be inserted into a field in a contact record!
Seems like one easy approach could be to take the date stored in a date field in a contact record, convert that date to a number (based on epoch time), then offer ability to add [n] seconds to that number (7.7 million seconds for 90 days), then simply convert the new number back into a date. Bingo.
Please sign in to leave a comment.
2 comments
Being able to set a specific amount of time to a date field would be great. Especially to allow people to pay early for their next year of membership.
The problem is that the only option currently in Ontraport is to add 1 year from the date the purchase transaction takes place, but not adding a year to their existing expiry date. For example, this means that if their expiry date is January 2, 2024 and they buy an annual pass on December 11, 2023, then their expiry date is put at one year from the date of purchase (December 11, 2024) instead of adding 1 year to the actual expiry date. This means that they are getting a shorter period than they should.
I have an Automation in Ontraport that needs this step, and Support gave a me a workaround using a Webhook Example, teh API, and some time specific code. But the straightforward ability to have this as an easily addable step would be much better.
Thanks!
Comment actions