Cab, I just finished my talk at KohaCon on SQL - there is a sample report in there for something like what you want: http://www.slideshare.net/nengard/sql-reports-in-koha-1301608 --- Nicole C. Engard Open Source Evangelist, LibLime (888) Koha ILS (564-2457) ext. 714 nce@liblime.com AIM/Y!/Skype: nengard http://liblime.com http://blogs.liblime.com/open-sesame/ On Thu, Apr 16, 2009 at 2:36 PM, Cab Vinton <bibliwho@gmail.com> wrote:

There doesn't seem to be a built-in report for Koha 3.0 that finds items added to the catalog after/ before a given date, or between two dates, & I'm not familiar with SQL syntax.

Is this something that can be done with the Reports utility?

Specifically, we'd like to use the dates in 952 $d ("Date acquired") to generate reports on our latest new materials (just author & title in most cases).

I presume this would be fairly simple if we were using the Acquisitions module, but we're not going that route, at least for the moment, because of the extra time involved.

Thank you,

Cab Vinton, Director Sanbornton Public Library Sanbornton, NH _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha