[Koha] Report help needed - modification date

Elaine Bradtke eb at efdss.org
Wed Sep 3 10:39:24 NZST 2014

How do I filter records based on the MARC 005?  DATE AND TIME OF LATEST
biblio.timestamp doesn't do it.

This is what I have:
FROM items LEFT JOIN biblioitems on
(items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on
(biblioitems.biblionumber=biblio.biblionumber)   WHERE biblio.timestamp >=
'2014-05-01' AND biblio.timestamp <= '2014-05-30' ORDER BY
biblio.biblionumber asc

In the guided report the option I chose was Modification date /

But after testing this I've discovered that  it isn't using the date in the
005.  I'm not sure where the  Modification date / biblio.timestamp
information is coming from, it's neither the creation date, nor the
modification date, but some other date entirely.

I'm trying to hunt down a batch of records modified on a certain date.
Thanks for any help.

Elaine Bradtke
Data Wrangler
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

More information about the Koha mailing list