Thanks for all your help, krileon Substitutions are working everywhere - for the Community Builder user list, my pdf certificate (this worked great for pdf generation -https://codepen.io/mooncake69/pen/MWaazyQ) , and all of substitutions are also working in the ACYmailing email EXCEPT the expiration date. The ACYMailing team have not offered any good solution. Is the subscription expiration date in a database field where the CB Query Field might be a possibility? These subscriptions last 5 years, so regular correspondence with the date are important to the organization.
Mary
webie-design.com