Constituency End Date

Hi James et al,

Here’s the situation: I was looking up a constituency for our Ballet School Students. I was attempting to pull our students last year (st dt: whenever / end dt: 5/16/2013) AND a separate list of our current students this year (st dt: 9/3/2013 / end dt: 5/13/2014).

So in actuality, the information I was trying to pull is “INACTIVE” as of today (8/29/2013). Last year’s constituency is inactive because the end date has past. The current constituency is inactive because the start date has yet to occur.

The “Constituency” list criteria element only pulls “active” constituencies. So when I paired it with my dates, the information I was asking for did not exist.

We created a “Constituency – ALL” to include active and inactive constituencies. However, to get accurate results this criterion must be paired with “Constituency Start Date” OR “Constituency End Date.” Otherwise, it will pull all records that have a particular constituency – active or inactive.

So to make a long story short, we did figure it out.

Thanks everyone for your help – much appreciated,

Hi Marie,

I'd expect to see some results if you used the criteria: 

Constituency - IN - Student
Constituency End Date < or = the end date of the campaign

The only reason i'd expect 0 results would be if for some reason the constituency disappeared off the persons records when it came to an end, which may be the case, i'd assume the constituency would have turned grey and inactive on their records when it hit the end date.

Maybe try doing it with constituency create date between start date and end date and see if that works? Not sure it will though.

Hi James et al,

Here’s the situation: I was looking up a constituency for our Ballet School Students. I was attempting to pull our students last year (st dt: whenever / end dt: 5/16/2013) AND a separate list of our current students this year (st dt: 9/3/2013 / end dt: 5/13/2014).

So in actuality, the information I was trying to pull is “INACTIVE” as of today (8/29/2013). Last year’s constituency is inactive because the end date has past. The current constituency is inactive because the start date has yet to occur.

The “Constituency” list criteria element only pulls “active” constituencies. So when I paired it with my dates, the information I was asking for did not exist.

We created a “Constituency – ALL” to include active and inactive constituencies. However, to get accurate results this criterion must be paired with “Constituency Start Date” OR “Constituency End Date.” Otherwise, it will pull all records that have a particular constituency – active or inactive.

So to make a long story short, we did figure it out.

Thanks everyone for your help – much appreciated,

Hi Marie,

I'd expect to see some results if you used the criteria: 

Constituency - IN - Student
Constituency End Date < or = the end date of the campaign

The only reason i'd expect 0 results would be if for some reason the constituency disappeared off the persons records when it came to an end, which may be the case, i'd assume the constituency would have turned grey and inactive on their records when it hit the end date.

Maybe try doing it with constituency create date between start date and end date and see if that works? Not sure it will though.