Hmm, I'm not really clear on where or how you've got the date info recorded. An advanced search of Date Description is going to search under Historical Dates (click the elipses next to Display Bio and it's in the lower half of the screen). Is that where you've got the info? If not, perhaps send a screenshot of where you've got the info. Or do you have it only in the DisplayBio without the BeginDate & EndDate populated? But, yes, you'll have a much happier time of it if you get those populated! Anybody there have some (basic) SQL skills & access to the backend of the database?

David Lowe
New York Public Library


On Thu, Jun 5, 2014 at 4:45 PM, Heather Pigat <[log in to unmask]> wrote:

Hello Wise TMSrs,

One of our fearless summer students is wrestling with TMS, and has the following enquiry.  We appreciate all replies and assistance – and yes, I know, we need to update our begin and end dates!!  Please feel free to reply to me off list if you prefer.

All best from Toronto!

 

Hello, I am having some difficulty pulling lists of constituents linked by a range of birth or death dates, and would appreciate any suggestions! For example, I might search for all constituents with death dates before 1950. Here is what I am trying: using the advanced query option, I select "constituent dates", and filter by "date description" (for example, "death date") and "remarks" (for example, less than or equal to 1950). The system is currently not updated with "begin dates" or "end dates". Do you have any tips or advice? Thanks!

 

 

Heather Darling Pigat

Collections Manager

University of Toronto Art Centre

15 King’s College Circle

Toronto, Ontario M5S 3H7

T 416.946.7090

F 416.971.2059

Cell 416.407.2653

 

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.


To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.