[Koha] Creating a Report to List Books published with a Date Range

[Paul A]

On 2019-04-29 6:44 a.m., Njideaka Tobechukwu wrote:
> Hi All,
> 
> Please, I am trying to create a report of my KOHA database to list books
> published within 2016-2019, in a tabular form having just the book title,
> author, and date of publication.  However, I do not know how to go about
> creating this report.

SELECT b.title, b.author, b.copyrightdate
FROM biblio b
WHERE b.copyrightdate BETWEEN '2016' AND '2019';

Note: this simplistically relies on "copyrightdate" 260$c, which Koha 
defines as "publication or copyright date from the MARC record".

Best -- Paul