Rogan, To answer your question, I was using the built-in Evergreen reports, and was pulling the “Publication Year (normalized)” from the Bib Record--Simple Record Extracts. I’m guessing that the normalization routine is doing something unusual when the date isn’t the standard four-digit year.
[cid:image001.png@01D373F0.7AA81F20]Irene Patrick Library & Information Management Systems Librarian NC Dept. of Natural and Cultural Resources 919.807.7413 | irene.patr...@ncdcr.gov 109 E. Jones St. | 4640 Mail Service Center Raleigh, North Carolina 27699-4600 Facebook<http://www.facebook.com/ncghl> Twitter<http://www.twitter.com/ncpedia> YouTube<http://www.youtube.com/user/statelibrarync> Website<https://statelibrary.ncdcr.gov/> Email correspondence to and from this address is subject to the North Carolina Public Records Law and may be disclosed to third parties. From: Rogan Hamby [mailto:rha...@equinoxinitiative.org] Sent: Tuesday, December 12, 2017 5:25 PM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: [External] Re: [OPEN-ILS-GENERAL] Publication Year in Reports CAUTION: External email. Do not click links or open attachments unless verified. Send all suspicious email as an attachment to report.s...@nc.gov<mailto:report.s...@nc.gov>. Hi Irene, Are you using the reporter table for this? I have seen this before there and not had the tuits to look into it in any depth since I've only seen it on rare occasions but checking a few data sets it's not hard to find examples under a number of scenarios and it's not hard to imagine a regular expression creating this result. It's probably worth a launchpad bag and some discussion on how to handle it. Maybe we should be checking for a four digit number and using it when found. Ultimately that table might get replaced with newer functionality of course as the pub date field itself isn't RDA friendly but that's another discussion. Rogan Hamby Data and Project Analyst Equinox Open Library Initiative phone: 1-877-OPEN-ILS (673-6457) email: ro...@equinoxinitiative.org<mailto:ro...@equinoxinitiative.org> web: http://EquinoxInitiative.org On Tue, Dec 12, 2017 at 4:38 PM, Patrick, Irene <irene.patr...@ncdcr.gov<mailto:irene.patr...@ncdcr.gov>> wrote: Has anyone ever noticed that there is some strangeness with the Publication Year in Evergreen reports? The Publication Year is normalized in the output, and there seems to be an issue with how the data gets normalized. Some examples of what I am seeing: 264 $c September 1, 2015 Publication Year in report: 1 264 $c October 6, 2017 Publication Year in report: 6 264 $c October 31, 2016 Publication Year in report: 31 When the date in the 264 is not simply the year, the normalization routine seems to be pulling out only a piece of the date, not the full date. I tried looking for any previous reports of this issue in Launchpad but didn’t find one. Apologies if it is there and I missed it. [cid:image001.png@01D373F0.7AA81F20]Irene Patrick Library & Information Management Systems Librarian NC Dept. of Natural and Cultural Resources 919.807.7413<tel:(919)%20807-7413> | irene.patr...@ncdcr.gov<mailto:irene.patr...@ncdcr.gov> 109 E. Jones St<https://maps.google.com/?q=109+E.+Jones+St&entry=gmail&source=g>. | 4640 Mail Service Center Raleigh, North Carolina 27699-4600 Facebook<http://www.facebook.com/ncghl> Twitter<http://www.twitter.com/ncpedia> YouTube<http://www.youtube.com/user/statelibrarync> Website<https://statelibrary.ncdcr.gov/> Email correspondence to and from this address is subject to the North Carolina Public Records Law and may be disclosed to third parties.