Is there a way to create a custom field so that I can run a list of constituents with a specific code that has expired? I have tried several SQL and not found the right one yet.
I just use list manager. I manually edit and slap this in. Works for me:
Select Distinct customer_no from tx_const_cust where constituency in(insert constuency ID here) and end_dt<'2017-06-01'
The list I need to gather includes over 300 constituents. Does this thread need to be done my ID #?
Not by constituent ID! :) By constituency ID number. If you don't know the ID of the specific constituency you're looking for you should ask your systems admin.