Hello everyone,
I am trying to identify a list of people with a definite End Date entered for a specific constituency, thereby currently de-activating that constituency in their record. The majority of names on this list should have an open ended 00/00/0000 entry in this field. As I am not IT, and we do not have an internal IT department I would ideally be looking for a solution that does not involve writing a procedure, if at all possible.
Any guidance you may have is greatly appreciated!
Thanks,
Duane
Do you have access to your system table T_KEYWORD? If so you could add Constituency End Date as a List Builder option and then pull a list of anyone that has an end date (Between would probably work best). If not, as a bit of a work-around you could run the Manage Constituency utility in Review Only mode on a list of everyone with the desired Constituency. In the report that comes up sort by End Date to see those that have one.
Hello Kjersten,
That's exactly what I was hoping I could do. My next issue then is that I have no idea what to put in the various columns for this parameter in T_KEYWORD (Detail Tbl, Detail Col, etc.) Do you have any advice there?