I need to have the current subscription expire date visible via a cb field (for use with another extension).
I would like to use the Integrations - CB Fields to set a cb filed (cb_subs_expire) to the value of the expiration date of the subscription being purchased.
I tried setting the Operator to Set: Field = Value and then in the Value area I added [SUBSCRIPTION_EXPIRY_DATE]; however, it appears that this type of substitution doesn't work in this field.
Can you let me know if there is any type of substitution (possibly a different syntax) that would automatically insert the exipry date into the field or exactly what I can put in this value area (can I insert any type of formula - i.e. NOW()+365 etc.)?