https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24869 Bug ID: 24869 Summary: When Marc Record uses brackets in the publication Year the value is stored in the database as null Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Cataloging Assignee: koha-bugs@lists.koha-community.org Reporter: kelly@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org CC: m.de.rooy@rijksmuseum.nl For multiple reasons are < or [ used in cataloging dates that are either unknown or with a range. These are three examples that do not work or get stored properly in Koha and the database. [19--] <1981-> [1981] Currently, if a publication year has the hard brackets or the hungry alligators with a year, the date does not get stored in the database as a value, but it stored as null. It would be nice if Koha were to display the year regardless of the < or [ . If a year is presented like this [19--], Koha should use the value of the year with 1900 in the database, and in a case such as this <1981->, it should be 1981. The database holds these values as NULL. When an item search in Koha is done with a record with one of these values, the publication year will display as 0, which is not helpful to a library when needing the publication date stored in the Marc Record. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.