Re: [Koha] Help with sql statement.

James, I am trying to get the new patron report developed by Sharon Moreland, to

do a date range and have a location selection for San Benito County Free Library. I am sure I am doing something wrong, please advise as necessary,

SQL:

SELECT b.code,c.code,COUNT(*) FROM borrowers WHERE DATE(dateenrolled) between <<Date between (yyyy-mm-dd)>> AND DATE(dateenrolled)= <<and (yyyy-mm-dd)>> and b.code=<<Pick your branch|branches>> GROUP BY c.code

You have an extra = after the second DATE(dateenrolled) Regards, Jared -- Jared Camins-Esakov Bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcamins@cpbibliography.com (web) http://www.cpbibliography.com/