[Koha] Circulation report limited with date

[Vimal Kumar]

Dear Friends,
I could generate the current checkouts with  following SQL query:

SELECT issues.issuedate,items.barcode,biblio.title,
author,borrowers.firstname,borrowers.surname FROM issues LEFT JOIN borrowers
ON borrowers.borrowernumber=issues.borrowernumber LEFT JOIN items ON
issues.itemnumber=items.itemnumber LEFT JOIN biblio ON
items.biblionumber=biblio.biblionumber ORDER BY issues.issuedate

Please help me to generate the same as per date limit. For example: I need
to generate report of current checkouts as of 29th March 2011. How shall I
modify the query so that I  can get the report limited with date.

With best regards


-- 
Vimal Kumar V.
Mahatma Gandhi University Library
Kottayam, Kerala- 686 560
Web: http://www.vimalkumar.co.nr
Blog: http://vimalkumar.oksociety.in http://linuxhalwa.blogspot.com
---------------------------------------------------------------------------
"I forget what I was taught. I only remember what I have learnt"
-Patrick White
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110419/452a0f56/attachment.htm