Document Management Reports

KX_Development_Support_Team_(merrilllynchglobaluse

Can someone help me with the following report (and similar): Documents older than xdate and not accessed since xdateI know how to retrieve the maxdate but how do I say, "where maxdate is less than x"We are trying to identify repository "clutter" than can be marked for archival.

Bhupinder_Singh

Message from Bhupinder Singh via eLinkThe following Oracle SQL query, taken from a Knowledge Base Article I wrote,may be of help:How do you subtract 2 weeks from a date parameter in a LiveReport usingOracle SQL? When creating a LiveReport, how can you configure it so that auser can put in a date and be able to retrieve information from a date rangeupto 14 days earlier? Using parameter %1 as a date field:select createdate from dtree where createdate < %1 and to_char(createdate,'yyyymmdd') > to_char(%1 - 14,'yyyymmdd') order by createdate ascWhat if you tried something like:where maxdate < to_char(xdate,'yyyymmdd')Sincerely,Bhupinder-------------------------------------------------------------------------Bhupinder Singh, B.Math., B.Ed. Customer SupportOpen Text Corporation Waterloo, Ontario, CanadaCustomer support e-mail: support@opentext.comCustomer Support Telephone: 800-540-7292------------------------------------------------------------------------------Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Thursday, May 15, 2003 6:29 PMTo: eLink RecipientSubject: Document Management ReportsDocument Management ReportsPosted by MerrillLynchGlobalUser1 on 05/15/2003 06:16 PMCan someone help me with the following report (and similar):Documents older than xdate and not accessed since xdateI know how to retrieve the maxdate but how do I say, "where maxdate is lessthan x"We are trying to identify repository "clutter" than can be marked forarchival.[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe