We sell annual subscriptions for our software. We keep a date field for when the user's subscription ends so that we can notify them of the pending expiration.

I am automating the whole subscription purchase option and would like to set this date field automatically.

The only date variable I can find is ~date.current~. Is there anyway to increment this by one year? Or is there any way to do math on dates? Or are there any other date variables?

We could switch to using the current date and do our sequences forward from that date but that means manually updating 500+ records . Also, it means we can't quote an expiration date in the notices we send out.

Any one have any suggestions?

Gregg
Trakware

Hi Gregg,

I know u are in the tech forum so you are probably wanting an api solution, but I have done test campaigns in the past and people can be removed by a final or completion date. See this doc here....http://community.infusionsoft.com/component/option,com_fireboard/Itemid,451/func,view/catid,16/id,7503/#7503 we can create a custom field for that date based on a year from when they sign up and then in the action sequences we can create a custom sequence to remove from groups and sequences based on a number of days before or after the date.

Hope this helps. This was for a previous post. Attaching my word doc for you to see screen shots.

Let me know if you need any further explination
Sharon Wainscott
Cress Mgmt Service
CMAC

A solution could be to run a small API script to compute the expiration date based on the registration date for the given subscription. That would take care of your 500+ subscriptions. Manually updating them doesn't sound like fun.

All future subscriptions could be handled automatically by adding a very simple java script to the order form, which would compute dates forward and backward from "now", as you wish.

This computed date value can then be stored automatically as a custom field in your contact DB for the respective contact/client, as part of the order process.

From then on, you will be able to query this custom field to determine what to do next with this subscriber.

Best,
Bob