[Koha] Date Wise List of Checked In Books

[Mark Alexander]

Excerpts from Scott Owen's message of 2017-01-27 08:08:43 -0500:
> SELECT old_issues.returndate,items.barcode,biblio.title,biblio.author,borrowers.firstname,borrowers.surname,borrowers.cardnumber,borrowers.categorycode
> FROM old_issues  LEFT JOIN borrowers ON
> borrowers.borrowernumber=old_issues.borrowernumber LEFT JOIN items ON
> old_issues.itemnumber=items.itemnumber LEFT JOIN biblio ON
> items.biblionumber=biblio.biblionumber WHERE old_issues.returndate
> BETWEEN <<Between Date (yyyy-mm-dd)|date>> AND <<and
> (yyyy-mm-dd)|date>>  ORDER BY old_issues.returndate DESC

I tried something like this on my installation, and it worked when
I put the dates in single quotes in the BETWEEN clause:

SELECT old_issues.returndate,items.barcode,biblio.title,biblio.author,borrowers.firstname,borrowers.surname,borrowers .cardnumber,borrowers.categorycode
FROM old_issues
LEFT JOIN borrowers ON borrowers.borrowernumber=old_issues.borrowernumber
LEFT JOIN items ON old_issues.itemnumber=items.itemnumber
LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber
WHERE old_issues.returndate BETWEEN '2017-01-19' AND '2017-01-22'
ORDER BY old_issues.returndate DESC;