[Koha] Help with sql statement.

[Jared Camins-Esakov]

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 at cpbibliography.com
(web) http://www.cpbibliography.com/