"Begin Date not equal to 0" works for us.

Sue Garton
Data Administrator
National Portrait Gallery
(202) 633-8554 / [log in to unmask]

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Meghan McQuaide Reiff
Sent: Thursday, August 15, 2013 11:05 AM
To: [log in to unmask]
Subject: Re: advanced query

We ran into the same issue when searching for works created before 1800.  Does anyone know of a way to filter out records without a date for a "before" date search?

Thanks,
Meghan



--

Meghan McQuaide Reiff
Assistant Registrar
Herbert F. Johnson Museum of Art
Cornell University
Ithaca, NY 14853-4001
607 254-4503
607 255-9940 (fax)
museum.cornell.edu<http://museum.cornell.edu>

From: The Museum System (TMS) Users [mailto:[log in to unmask]]<mailto:[mailto:[log in to unmask]]> On Behalf Of Christine Droll
Sent: Wednesday, August 14, 2013 5:49 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: advanced query

Try searching on "Begin Date" in the Object Cataloguing field group.

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Anne Crouchley
Sent: Wednesday, August 14, 2013 4:36 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: advanced query

Hello TMSers,

I am trying to do an advanced query search in our collection for works on paper after 1960. Unfortunately, the records without any dates that are showing up in the search results (and there are many). Is there any way to remove the records with no dates from an advanced query?

Thank you,
Anne

Anne Crouchley
Joslyn Art Museum
Assistant Registrar
(402)661-3882 - Direct Line


[R2C]

To unsubscribe, send an email to [log in to unmask]<mailto:[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]<mailto:[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]<mailto:[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.