<div dir="ltr">Hi Blake,<div><br></div><div>Could you pull it from the 008 field? You'd want to use 008/07-10 (Dates: Date 1), and 008/011-14 (Dates: Date 2) if you wanted both.</div><div><br></div><div>Take care,</div><div><br></div><div>Carol</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Feb 16, 2024 at 11:23 AM Blake Graham-Henderson via Evergreen-reports <<a href="mailto:evergreen-reports@list.evergreen-ils.org">evergreen-reports@list.evergreen-ils.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hello all,<br>
<br>
We're wrestling with the idea of reporting the average publication year <br>
for a set of items on certain shelves. As we all know, the publication <br>
year comes out of the MARC, and includes lots of non-digit characters <br>
like copyright symbols, brackets, parenthesis, etc. So it would seem we <br>
can't use that for an average. What is everyone else doing for this? Or <br>
are you?<br>
<br>
-- <br>
-Blake-<br>
Conducting Magic<br>
Will consume any data format<br>
MOBIUS<br>
<br>
_______________________________________________<br>
Evergreen-reports mailing list<br>
<a href="mailto:Evergreen-reports@list.evergreen-ils.org" target="_blank">Evergreen-reports@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports</a><br>
</blockquote></div><br clear="all"><div><br></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr"><span><div dir="ltr" style="margin-left:0pt" align="left"><table style="border:none;border-collapse:collapse;table-layout:fixed;width:468pt"><colgroup><col><col width="492"></colgroup><tbody><tr style="height:0pt"><td style="border-width:1pt 1.5pt 1pt 1pt;border-style:solid;border-color:rgb(255,255,255) rgb(22,65,111) rgb(255,255,255) rgb(255,255,255);vertical-align:top;overflow:hidden"><br><span style="border:none;display:inline-block;overflow:hidden;width:139px;height:95px"><img src="https://lh7-us.googleusercontent.com/BTeYvD845QYnbO00n7bcW0mkegZXE2em5ARs9Wf2nWywbVWwERY-OX2hNhHa5Q2bUtHqfHmJqPsAmqE27SIVQB1EylOXG6umU4lTi_eVtiYgPCsvPRceJaJ5NIfnQt0g1zNfQ9Xzx1BQb4IXQfBr_h8" width="139" height="95" style="margin-left: 0px; margin-top: 0px;"></span></td><td style="border-width:1pt 1pt 1pt 1.5pt;border-style:solid;border-color:rgb(255,255,255) rgb(255,255,255) rgb(255,255,255) rgb(22,65,111);vertical-align:top;padding:12.168pt;overflow:hidden"><p dir="ltr" style="line-height:1.62;margin-top:0pt;margin-bottom:0pt"><span style="font-size:12pt;font-family:"Lucida Sans",sans-serif;color:rgb(22,65,111);background-color:transparent;font-weight:700;vertical-align:baseline">Carol Witt</span><span style="font-size:13.5pt;font-family:"Lucida Sans",sans-serif;color:rgb(22,65,111);background-color:transparent;font-weight:700;vertical-align:baseline"> </span><span style="font-size:10pt;font-family:"Lucida Sans",sans-serif;color:rgb(22,65,111);background-color:transparent;vertical-align:baseline">(she/her)</span><span style="font-size:13.5pt;font-family:"Lucida Sans",sans-serif;color:rgb(22,65,111);background-color:transparent;vertical-align:baseline"><br></span><span style="font-size:10pt;font-family:"Lucida Sans",sans-serif;color:rgb(33,33,33);background-color:transparent;vertical-align:baseline">Bibliographic Services Supervisor, C/W MARS, Inc.</span></p><p dir="ltr" style="line-height:1.62;margin-top:0pt;margin-bottom:0pt"></p><hr><p></p><p dir="ltr" style="line-height:0.891;margin:1pt"><span style="font-size:9pt;font-family:"Lucida Sans",sans-serif;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline"><span style="border:none;display:inline-block;overflow:hidden;width:20px;height:20px"><img alt="icon" src="https://lh7-us.googleusercontent.com/q2gbyNougapcDYhTiiAoMKelbfwl4oBcCuMyNmB7_bZgeRWYtCUSnQrPi8ab68yROW1C6B8se31KU4wjTYdlzuinue7h_Xi97ZJu6C6xr3EqCqgVazE_rD3pp-MYKD5TJaW_8Sso8VUemhZ3ZgWVK-k" width="20" height="20" style="margin-left: 0px; margin-top: 0px;"></span></span><span style="font-size:9pt;font-family:"Lucida Sans",sans-serif;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline"> </span><a href="mailto:wittc@cwmars.org" target="_blank"><span style="font-size:9pt;font-family:"Lucida Sans",sans-serif;color:rgb(17,85,204);background-color:transparent;vertical-align:baseline">wittc@cwmars.org</span></a><span style="font-size:9pt;font-family:"Lucida Sans",sans-serif;color:rgb(0,0,0);background-color:transparent;font-weight:700;vertical-align:baseline"> | </span><span style="font-size:9pt;font-family:"Lucida Sans",sans-serif;color:rgb(0,0,0);background-color:transparent;font-weight:700;vertical-align:baseline"><span style="border:none;display:inline-block;overflow:hidden;width:20px;height:20px"><img alt="icon" src="https://lh7-us.googleusercontent.com/GPO7gOK3AuNSm_waxnVGOu-PeKE-f640ESs-EXBt-eXrjP9hB2u1wmYQTJpmJLFLftYqtpCw8ltF6CBPooVqCLY5dgi3VYt9icN3ee_C9lFkhUm82tiw5ko3bHcS2TG__DE16fQw4l1VbUVjSZi7eMY" width="20" height="20" style="margin-left: 0px; margin-top: 0px;"></span></span><a href="https://www.cwmars.org/" target="_blank"><span style="font-size:9pt;font-family:"Lucida Sans",sans-serif;color:rgb(33,33,33);background-color:transparent;vertical-align:baseline">www.cwmars.org</span></a></p><p dir="ltr" style="line-height:0.891;margin:10pt 1pt 1pt"><span style="font-size:9pt;font-family:"Lucida Sans",sans-serif;color:rgb(0,0,0);background-color:transparent;font-weight:700;vertical-align:baseline"><span style="border:none;display:inline-block;overflow:hidden;width:20px;height:20px"><img alt="icon" src="https://lh7-us.googleusercontent.com/WVVHVDQPC1RdxWy1cXUgwZCioM6tDySYHtda3ZPPSC8CP1-_gc-0vQDpWNAIRX21VJAyP2mwtUcnLjE7ULN1Mz1rI_j2TUYPQ2HmeK666QOf-U-J4jFv3-hyLjW-ztWd5_wmzoXXDmi7P3fBnbrFc44" width="20" height="20" style="margin-left: 0px; margin-top: 0px;"></span></span><span style="font-size:9pt;font-family:"Lucida Sans",sans-serif;color:rgb(0,0,0);background-color:transparent;font-weight:700;vertical-align:baseline"> </span><span style="font-size:9pt;font-family:"Lucida Sans",sans-serif;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline">508-755-3323 x 3</span></p></td></tr></tbody></table></div></span></div></div>