Dear List Gurus,
I'm trying to use MonRunDate +/- but don't think I'm using it right.
What I'd like to do is pull a list of members who lapsed and became inactive 6 months before the date of my query. I tried referencing the expiration date, +5 months (assuming a lapsed member changes to an inactive one at one month past their expiration). However, when I used +5 the results showed active members.
For status, I have tried both:
I'd like to contact members when they haven't been active for half a year. I would like to run this query once a month when I have time. What list criteria would I need for this? Preferably using one list that I keep generating results from and exporting content outputs throughout the year.
Thanks,
JM The Neon Museum Las Vegas
Hi JM,
If you want to find people with expiration dates that were 6 months prior to the date you are running a list, you would do -6 months on the expiration date criterion. If you have been entering +5 months that will give you people who have expiration dates in the future, hence your results selecting active members.
-Kevin