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) jcam...@cpbibliography.com (web) http://www.cpbibliography.com/ _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
