Our Family Genealogy Pages

Home Page  |  What's New  |  Photos  |  Histories  |  Headstones  |  Reports  |  Surnames

First Name:

Last Name:

Report: Document changes

         Description: Documents/histories changed within the last 90 days (listing *without* linked individuals)

Error: The syntax of the query run with this report (ID: 32) was incorrect, and as a result the report could not be run. Please contact the system administrator at John@rosique.net.

Query: SELECT dc.docID, description, notes, dc.changedate FROM tng_docs AS dc LEFT JOIN tng_doclinks AS dcl ON dc.docID=dcl.docID WHERE DATE_SUB(CURDATE(),INTERVAL 90 DAY)<=dc.changedate ORDER BY dc.changedate DESC
Error Message: