"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.