Hi Eddy,

We just delete the auto-populated date in the end field date and leave it
blank.

Sincerely,

Lucille


On Tue, Aug 5, 2014 at 5:50 PM, Eddy Almonte <[log in to unmask]
> wrote:

>  Hey everyone,
>
>
>
> I’m wondering how everyone uses artist’s birth and death dates in the
> Constituents module. In our TMS, we use the Begin and End Search Date
> fields. If an artist is still active and alive, we just fill the Begin
> Search Date with the year they were born and TMS automatically fills the
> End Search Date with that same year. If we know the time of death, then we
> fill the End Search Date field with that year. For example, if an artist
> was born in 1979 and is still alive, both the Begin and End Search Date
> fields will have 1979 filled in.
>
>
>
> This hasn’t been a problem until I’ve recently tried to query all active
> artists in our collection who are still alive. This wouldn’t be an issue if
> the End Search Date field were blank or ‘0’, for example. Should that field
> be blank since the beginning? Would doing an advanced search of
> Objects-related constituents with End Search date equal to ‘0’ would have
> solved my query problem (if all End Search Dates were zero for alive
> artists)? I would love to hear how other institutions are using these
> fields.
>
>
>
> Thanks in advance!!
>
> Eddy
>
>
>
> *Eddy Almonte*
>
> Assistant Registrar
>
> Colección Patricia Phelps de Cisneros
>
> 2 East 78th Street
>
> NYC 10075
>
> T 646.448.8324 <212.717.6080>
>
> *www.coleccioncisneros.org <http://www.coleccioncisneros.org/>*
>
> *www.orinoco.org <http://www.orinoco.org/>*
>
> *conversaciones/conversations <http://vimeo.com/62726873>*
>
> *find us on facebook <http://www.facebook.com/cisneroscollection>*
>
>
>  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.
>



-- 
Lucille Stiger
Registrar
Allen Memorial Art Museum
440.775.8668

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.