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; _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
