• Replies 10 replies
  • Subscribers 413 subscribers
  • Views 130 views
  • Users 0 members are here
Related

Pulling Constituency withe End Date

Marie Kocher
$organization

Hello All, 

I have a constituency with a start and end date that has passed. I want to pull a list of those records. 

My list criteria is as follows:

Constituency - IN - student

Constituency End Date - = - 5/16/13

This is not giving me any results. What step am I missing?

Thanks, 

Marie Kocher

Development Assistant

Kansas City Ballet

500 W Pershing Rd

Kansas City, MO 64108

(816) 931-2232 x 1382

mkocher@kcballet.org

Parents
  • $organization

    Hi Marie,

    To expand more on Terry's suggestion, I don't use any date field with the = operator if I can help it. :)

    In Tess most dates have a hidden time attached to them at the end. So by searching for date = (some day) you may not get the right results. I would suggest doing a search using Constituency End Date BETWEEN '5/15/13/ and '5/17/13' to see if that gets the results you are looking for.

    Hope that helps!

Reply
  • $organization

    Hi Marie,

    To expand more on Terry's suggestion, I don't use any date field with the = operator if I can help it. :)

    In Tess most dates have a hidden time attached to them at the end. So by searching for date = (some day) you may not get the right results. I would suggest doing a search using Constituency End Date BETWEEN '5/15/13/ and '5/17/13' to see if that gets the results you are looking for.

    Hope that helps!

Children
No Data