Our development department needs to send letters that include the last level of membership and the date that it expired. Using output set elements it is easy to grab this info for a list of current members, but when the same set is applied to a list of expired members those two fields are blank. The Constituent Profile report pulls old membership info, so clearly there is a way to access it. Has anyone else encountered this and found a way to get that info out in a way that can be used to export for letters and reports?
Also, they have tried to pull a list of members for a specific date range (for example 1/1/19 – 12/31/19). If the constituent is a current member, their current level of membership appears not the level for the date range. Of course, in most instances they are the same, but not all.
Any insight would be much appreciated.
Thanks!Anne
I am actually trying to pull last membership expiration date too and am running into this issue. Were you able to figure it out? Would you mind sharing your insights? Thank you in advance!
Hi Dulce -- Scott Colby (Past Member) sent me the SQL code to set up a view that I was then able to use to create some new output set elements. In looking at the email chain it looks like we went back and forth a few times. Scott -- do you want me to forward the chain? Or do you want to send something?