Hi,
We would like to send a Disposition notification with a report to our Admin users 90 days prior when documents in a cabinet reaches dispostion/Final phase. i.e., if a document is ready for dispostion or entering into FINAL phase on Dec 12, 2011 we would like to send a notification/report to Admin users on Sep 12, 2011 (approx).
Could anyone please help us with a DQL so that we can schedule a job to create report and send it to users. We are running in D6.7.
Thanks,
Sivaselvi.