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
Thank you Beth,
I did try different operators for my date “range” and received the same results. I believe my criteria are custom and am waiting for a reply from my internal DBA. Thank you for the suggestion. It was good for me to try.
Marie
--
Marie Kocher | Development Assistant
Todd Bolender Center for Dance and Creativity
500 W Pershing Road
816-931-2232 x 1382 | 816-931-1172 (fax)
Buy tickets and enroll for classes: www.kcballet.org
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Beth Hawryluk Sent: Tuesday, August 27, 2013 2:07 PM To: Marie Kocher Subject: Re: [Tessitura Development Forum] Pulling Constituency withe End Date
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!
From: Marie Kocher <bounce-mariekocher5698@tessituranetwork.com> Sent: 8/27/2013 1:09:52 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!