Hi all,

In the interest of the eternal holy grail style quest to create an automated way to report out on display times for objects en masse I was wondering if anyone has approached it from a location change perspective? At CB we only make exhibition records for named shows, though we are starting to have interns work through a backlog of historical exhibitions. Either way we want to avoid the manual data entry mandated by calculating display times from exhibition records.

We do however have a rigorous and highly accurate set of location moves. I'm interested in using CR or a Dataview to run math on the move date of sets of moves based on the Purpose (Exhibition or Loan) which is followed by a move to Storage (Short or Long Term) and then repeat for every instance, culminating in a total amount of display time.

Is this nuts to try to attempt to do in CR? I know date math can get janky at the best of times.

Jeremy Munro
Collections Information Coordinator

Crystal Bridges Museum of American Art
600 Museum Way
Bentonville, AR 72712

479.418.5710 (direct)
479.418.5700 (main)
CrystalBridges.org<http://crystalbridges.org/>


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.