How can I pull a list based on Constituency end date?
Looks like you're going to need to create a new list criteria in the t_keyword table. I'd use the vx_const_cust view as a referance. Hope that helps
It would be easy to manually add this if a)you have access to the Manual Edit button in List Manager and b)you're confident with adding the appropriate syntax. Happy tohelp of you want to contact me directly.
Sorry to disagree with a colleague but don't reference the view VXS_CONST_CUST as this will (by it's very nature) exclude any constituency that is not current. Not normally a good idea but reference the TX_CONST_CUST table directly.
Martin